you're welcome

"Kirk P." wrote in message
...
Perfect. thanks.

"JulieD" wrote:

Hi Kirk

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

Cheers
JulieD

"Kirk P." wrote in message
...
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.