Excel 2007 : Removing Duplicates From Excel 2007

Hello Friends,

This is my first post in this forum.

I have a situation here:-

Please refer to the attached spreadsheet and kindly advise me on the suggested way to solve this issue:-


In the attached spreadsheet, you will see that there are 2 type of duplicate entries:

Duplicate 1 -

It is that data where the URL and all other fields are same.

Duplicate 2 -

It is that data where the URL is same but the corresponding data is different.

What I want to do is -

Suppose I want to keep only Unique URLs and their corresponding data in the xls. How can I do that?

Note:- As for which row to keep in case of duplicate 2 - Any of them.

Kindly advise how do I get this done.

Thanks a lot in advance