Removing duplicates in a list

[Greg Hadrych]

I know there is a way to do this, i just can not figure it
out. If i have a list long list of numbers and some of
them are duplicates, is there a formula or VB code that
will go through the list and remove the duplicates?

 

[JulieD]

Hi Greg

check out

http://www.cpearson.com/excel/duplicat.htm

Cheers
JulieD

 

[Frank Kabel]

Hi
one way: use 'Data - Filter - Advanced Filter' and check 'Unique
entries'