Forum Discussion
Solved
Search for most recent date in a list
I'm trying to search a massive list of data for the most recent transaction date for a specific region and then return said date to a cell. I'm sure I'm overcomplicating things but does anyone know w...
Are the source data in a table? If so, let's say it is named DataTable
In your overview table, enter the following formula in the Date column:
=MAXIFS(DataTable[Transaction Date], DataTable[Franchise], [@Location])
Excel should automatically propagate the formula to the entire Date column.
If the dates are displayed as numbers, select the Date column and apply a date format.
Are the source data in a table? If so, let's say it is named DataTable
In your overview table, enter the following formula in the Date column:
=MAXIFS(DataTable[Transaction Date], DataTable[Franchise], [@Location])
Excel should automatically propagate the formula to the entire Date column.
If the dates are displayed as numbers, select the Date column and apply a date format.
Thanks so much, this worked perfectly