ExcelBanter - Finding Unique Values in Column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Finding Unique Values in Column (https://www.excelbanter.com/excel-discussion-misc-queries/6735-re-finding-unique-values-column.html)

Kirk P.

Finding Unique Values in Column

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.

JulieD

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.

All times are GMT +1. The time now is 02:34 AM.