Finding duplicates in an excel sheet

The_KiD · 2 May 2006 at 15:59

Right I have an excel sheet, which is one column with a load of web addresses in.

Is there anything I can run or do to automatically run through it and remove any duplicate's ?

div0 · 2 May 2006 at 16:06

Select the column - click Data - Filter - Advanced Filter - (make sure selected range highlighted is correct) - click "unique records only"

Done

The_KiD · 2 May 2006 at 16:23

dude I love you

div0 · 2 May 2006 at 16:29

sssshhh dont tell everyone

they'll get jealous