Finding the highest stage an applicant got to?

Hi all,

So I have been asked to create a list of which stage applicants applying for different positions got to at my work. I have this is a large excel list which I have sorted by Last name, first name and then date. This lists the last stage they got to at the top next to their name (please see attachment). is there anyway I can do something in excel which will show only the top record of each person so I can quickly get this analysis (so excel only shows the top date for each applicant, if you see the attachment I have highlighted the results I would like)? I do hope so!
APPLICANT SAMPLE.xlsx

Hi there

Create a new list with the highest stage please!

Oh wow thansk so much! I have just embedded this into my real sheet and have changed the range from A26 to A5373 as thats how many records they are. I see that I have to confirm the array formula but how do I do that for such a large number of rows? Do I highlight column F and H separately and do this or is there another way?

OK great I am going to try this. Thanks so much for your help. I have never used VBA ever, how do I go about getting started with that for this need?

Hi there again

Due ot the number of rows I have this isn't running very well. Can someone help me do the same thing but without the H column. I don't need the date column just the persons name and the highest position they got to. I think this might help speed up the array.

Oh I see thanks!!! I did look at yours and it looked great but didn't know it worked on two helper columns. I am going to try this now. Thanks so much!