Return value based on latest date for entry

[tamiwsw09]

Hi

I have a spreadsheet with factory name, review date and overall evaluation. Some factories may have multiple entries and reviews.
I would like the overall evaluation 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

Tami

 

[jorismoerings]

Hi Tami,

This is the first response to your question on MrExcel.

In many cases we're able to help but to do so we require information to go on and we live by a set of rules and use guidelines we all use on MrExcel.
This is not to make your life difficult but just to make sure if somebody responds to your question, he/she gets all the information necessary to actually be able to help you!

Unfortunately your post didn't provide the information needed to help or solve your issue.
So instead of a answer i've got a request. Can you take a look at the Forum Rules and also useful to look at Forum Guidelines and create an update of your question in a next post. By doing that you'll help us to help you!