How to delete the remaning duplicate rows leaving the first

[amethystfeb]

Hi,

I have a column containing user name, for example :

if there are 4 duplicates in column A, I want to remove the remaining 3 rows of the duplicates leaving the First duplicate.

[satputenandkumar0]

Dear amethystfeb,

Try bleow.

Please Login or Register  to view this content.

Regards,
Nandkumar S.

[amethystfeb]

Thnks a lot.. it worked perfectly... can u please explain in d if condition wat does > 1 mean