Formula Help



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



By: Tami

One thought on “Formula Help

Leave a Reply

Your email address will not be published. Required fields are marked *