Formula Help

Hi

 

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

 

Tami

By: Tami

One thought on “Formula Help

Leave a Reply

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