Date | Name | Exercise | Status | LastTimeStatus
-----------------------------------------------------------------------------
From my above columns in my spreadsheet, I am trying to automatically populate LastTimeStatus with data from the Status column.
I wish to match the Name and Exercise, then find the most recent date from the matches (excluding today)
See attached spreadsheet. The final column in the table shows where the status should have come from.
Should I be using MAX, V/XLOOKUP, MATCH or AND?
[excuse the multiple files, there was no delete files option - the last one is the correct file]
Hello,
I assume you have Excel 365 and thus MAXIFS function.
Try with following formula: =MAXIFS([Status],[Exercise],"*"&[@Exercise]&"*",[Name],[@Name],[Date],"<"&[@Date])
See attached file for reference.
Br,
Anders
Great. That works well Anders.
Thanks heaps 🙂
