NewOneInVBA
New Member
Members
Forum Posts: 2
Member Since:
September 2, 2022
September 2, 2022
Offline
Hello,
I wanted to make an Excel list that shows if it has assigned a task. The wanted result can be found in the picture below.
As you can see in the picture, the green version doesn't have any text that only contains rooms.
Do ask if this post was not clear enough. Thank you in advance!
BR, Excel noob
Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members
Trusted Members
Moderators
Trusted Members
Moderators
Forum Posts: 845
Member Since:
January 31, 2022
January 31, 2022
Online
If you are on a MS365 or in the web version, this formula could work (assume the blue table is called Table1):
=BYROW(FILTER(Table1,Table1[Tasks]<>""),LAMBDA(arr,TEXTJOIN(" ",,arr)))
A working example is attached. If this isn't working for you, please let us know your Excel version.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Fluff, Riny van Eekelen, Shraddha Sureka, Jordan Helman
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 287
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Ben Tooke
Kelsey Fennell
Jeffree Bunning
Jackie Memije
John Franzon
Darcie Clayton
trevor mir
Ruby White
Marisa Bradshaw
Eugene Augustine
Forum Stats:
Groups: 3
Forums: 24
Topics: 6872
Posts: 30122
Member Stats:
Guest Posters: 49
Members: 33669
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —