MAX and COLLECT
A different phrasing of my earlier question with a better "picture" to explain what I need.
I need to look up the MAX date for a task # on a sheet which houses all of the historical data for the completion of various tasks.
So, Two sheets. One Sheet is a "Master Task Sheet" with each task only appearing once. I need to add a formula to this sheet to look up the most recent completion date on sheet two. Sheet two is a history sheet with one line for each time the task has been completed.
I thought I could use the MAX and the COLLECT functions to "Collect" the data based on task ID and return the MAX from the "Completed Date" column. But I am apparently not understanding the syntax.
Any help would be much appreciated
Help Article Resources
Check out the Formula Handbook template!