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

​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  Read More

​