| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) | |||
| How do I get unique values from 2 columns? | Excel Discussion (Misc queries) | |||
| Finding the max of a column where values less than a specified number | Excel Worksheet Functions | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
| How do I count or display unique data in a column? | Excel Worksheet Functions | |||
Linear Mode
