Duplicates in a list

[William]

Is there a way to remove duplicate entries from a list
other than deleting them one by one?

 

[JulieD]

Hi William

have a look at
http://www.cpearson.com/excel/duplicat.htm

lots of fun stuff there to do with duplicates

Cheers
JulieD

 

[Andy B]

Hi

Have a look here:
http://www.cpearson.com/excel/duplicat.htm

Hope this helps
Andy.

 

[Frank Kabel]

Hi
see
http://www.cpearson.com/excel/deleting.htm#DeleteDuplicateRows

 

[Aladin Akyurek]

Also:

http://216.92.17.166/board2/viewtopic.php?t=73509

for an efficient formula-based approach.