Excel - Find the most recent visit date of your patients

 

Excel - Find the most recent visit date of your patients

A friend of mine, who is a doctor, came to me seeking help with a problem in Excel.
He said: "I have this list of patients and their visit dates, all mixed up in an unsorted list.

I want to know, for each patient, which is his/her most recent visit date.
And I'd prefer the simplest method in Excel since I don't want to use complicated formulae.

Can you please help me?"

So here is the data:

Pic No.1: Original List

And here a simple solution using a Pivot Table:

 

Pic No.2: Pivot Table Solution