Finding Unique Values in Column

K

Kirk P.

I have a column of account numbers such as

723031
723032
723034
723031
723031

Can Excel find and display only the UNIQUE items in this column? I don't
want to see any account numbers that may be repeated.
 
J

JulieD

Hi Kirk

click in the column
choose data / filter / advanced filter
tick unique records only
click OK

Cheers
JulieD
 
Top