Removing duplicates in a list

G

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?
 
F

Frank Kabel

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