Filter highest diploma

hello guys ,

i have an excel that contains 1000 rows ... Capture.PNG
as you can see in the example ... i have IDs for the same person i need to get the row with the highest degree ... for example if ID 1 has bachelor as highest degree i need that row to show up
and if ID2 has bachelor and masters degree i need the masters degree to show up only ... im trying to create a new excel sheet with the highest degree for the people but it is really time consuming going over each ID one by one

how can i do that

thank you

In your example, does John have 4 different Masters degrees and two Batchelors, or are they duplicates?

You could have a table of Qualifications arranged in order from lowest to highest, and then use the MATCH function to convert them into an equivalent number. From that you can use the MAX function to define the highest qualification, and extract that to another sheet.

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Don't try to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete

John has different masters and different bachelor's... Thank you guys... I will try your suggestions and get back to you

thank you KOKOSEK i tried your method and it worked fine .