This is following on from another tutorial I did on using a formula to update the status of tasks in a project. So in this one I want to show you how to use a range of dynamic array functions to view the data.
This is the starting file (finishing one from the tutorial)
I use the Unique() and Sort() function to extract a unique list of Assigned names and statuses. I then used the Filter() function to extract a list from the Project list that match the entries there.
You can download the completed file here