Screen through to extract highest education qualification

[KC]

Hi

in a scenario whereby I have a listing of employee records, each employees
with more than 1 row of education records, e.g. from elementary to college or
masters...

in such case, is excel able to screen through to extract the highest
qualifications out for me?

i am able to sort them out but will still require manual labour to extract
the highest qualifications for each employee.

i'm refering to a scenario whereby i have few thousands of records which
manual extraction is strongly not advisable.

thanks! =)

 

[Joel]

Adding an auxilary column will help

=IF(COUNTIF(A1:A100,A1)>1,IF(COUNTIF(B1:B100,"Masters")>1,"Masters",IF(COUNTIF(B1:B100,"College")>1,"College","Elementary")),B1)

this formula will put only the highest education level in the auxilary column.

A1:A100 is the persons name. If list more than once than there will be more
than one entry. If only one then the last B1 will display the one netry.

B1:B100 is the education level listed as Master, College, or elementry.