SOLVED

Search for most recent date in a list

Copper Contributor

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

Screenshot 2024-07-02 152827.pngScreenshot 2024-07-02 152845.png

2 Replies
best response confirmed by EthanGardner (Copper Contributor)
Solution

@EthanGardner 

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
1 best response

Accepted Solutions
best response confirmed by EthanGardner (Copper Contributor)
Solution

@EthanGardner 

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.

View solution in original post