Notifications
Clear all
General Excel Questions & Answers
4
Posts
3
Users
0
Reactions
49
Views
Topic starter
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
Posted : 20/12/2022 6:19 am
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.
Posted : 20/12/2022 9:52 am
Cross-posted here:
Posted : 20/12/2022 10:26 am
Using just native Excel features, you could select filter on the Data Tab and unselect blanks.
Posted : 20/12/2022 5:21 pm
