Hi All
Attached is a sample sheet with tasks to be completed.
They all have unique IDs, Status and completion dates
On Sheet 2, I would like to show the tasks that are to be completed for the date (today) shown in B3 and an entire list of open tasks.
However, I would like this to be concatenated into once cell if at all possible.
Sample data on sheet 2 what I would like to be shown is in RED
There are limitations here though as this is Excel 2013 and you cannot use "TEXTJOIN"
Any help please.