I'm trying to retrieve the most recent data from a column for a particular item. I've attached the spreadsheet to make it easier to explain.
The Latest Ratings sheet has 2 Funds, the rating of that Fund, and the date of the rating.
The Rating History sheet is a history of all the ratings, which the user can add to over time.
I need the the latest ratings data to be retrieved from the history.
I'm hoping a formula will suffice, but can't think of one because it goes beyond a simple index match combo.
Thanks so much.