Removing Duplicate key and selecting one record based on each id

[MrOnlyOne]

[TABLE="width: 537"]
<colgroup><col span="2"><col><col></colgroup><tbody>[TR]
[TD] (A)
User ID[/TD]
[TD] (B)
Username[/TD]
[TD]
(C)
Highest Education Level[/TD]
[TD] (D)
Qualification Obtained[/TD]
[/TR]
[TR]
[TD="align: right"]1001[/TD]
[TD="align: right"]1001[/TD]
[TD][/TD]
[TD]Postgraduate Certification[/TD]
[/TR]
[TR]
[TD="align: right"]1001[/TD]
[TD="align: right"]1001[/TD]
[TD][/TD]
[TD]Bachelors Degree[/TD]
[/TR]
[TR]
[TD="align: right"]1001[/TD]
[TD="align: right"]1001[/TD]
[TD][/TD]
[TD]Masters Degree[/TD]
[/TR]
[TR]
[TD="align: right"]2001[/TD]
[TD="align: right"]2001[/TD]
[TD][/TD]
[TD]Bachelors Degree[/TD]
[/TR]
[TR]
[TD="align: right"]2001[/TD]
[TD="align: right"]2001[/TD]
[TD][/TD]
[TD]Vocational/Technical/Trade Certificate[/TD]
[/TR]
[TR]
[TD="align: right"]2003[/TD]
[TD="align: right"]2003[/TD]
[TD][/TD]
[TD]Diploma[/TD]
[/TR]
[TR]
[TD="align: right"]4020[/TD]
[TD="align: right"]4020[/TD]
[TD][/TD]
[TD]Diploma[/TD]
[/TR]
[TR]
[TD="align: right"]4020[/TD]
[TD="align: right"]4020[/TD]
[TD][/TD]
[TD]Junior High/O Levels[/TD]
[/TR]
</tbody>[/TABLE]


I need help in filling up the highest education level column. The ranking is as follows:

Doctoral Degree (PHD)	1
Masters Degree	2
Postgraduate Certification	3
Bachelors Degree	4
Diploma	5
Senior High/A Levels	6
Vocational/Technical/Trade Certificate	7
Junior High/O Levels	8
Secondary and below	9

<tbody>
</tbody>

In conclusion: i only want the highest qualification and only one record for each user id

This is my code for the highest education level but i need help in removing duplicate and selecting the highest education level.

=IF(D2="Doctoral Degree","Doctoral Degree",IF(D2="Masters Degree","Masters Degree",IF(D2="Postgraduate Certification","Postgraduate Certification",IF(D2="Bachelors Degree","Bachelors Degree",IF(D2="Diploma", "Diploma",IF(D2="Senior High/A Levels","Senior High/A Levels",IF(D2="Vocational/

Thanks in Advance.

 

[MrOnlyOne]

Re: Help with Removing Duplicate key and selecting one record based on each id

For instance user id 1001, should be only one record and the highest education level is Postgraduate in this case.