I have a spreadsheet with factory name, review date and overall evluation. Some factories may have multiple entires and reviews.
I would like the overall evluation to return based on the latest review for each factory. Therefore if i have a duplicate factory on two review dates and the latest being accepted and the other follow-up, the value to return is accepted as it is the latest review outcome.
Hope this makes sense.
Thanks in advance