Return value based on a MAX date and other criteria
Is it possible to create a summary report that shows the individual rows of data based on the latest date (Date of Completion) and other columns so as to only show 1 row per location (multiple locations can occur in a single building) - See example image below
The items in green have the latest dates against their respective locations and would pull through from the Source Data (top) to the Summary Report (bottom)
Help Article Resources
Check out the Formula Handbook template!