Forum Discussion
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 what sort of formula I should be using. I have attached some screenshots for some added info. Thanks
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.
2 Replies
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
