| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to exclude unique values from a column?
How do I exclude all unique values from a column of data?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to exclude unique values from a column?
In an adjoining column use a formula similar to the one below and fill down.
It assumes your data starts in cell B5... =COUNTIF($B$5:$B$50,B5) Now use auto filter and custom filter on those items that are < 1. Copy the list and paste where ever. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) wrote in message How do I exclude all unique values from a column of data? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to exclude unique values from a column?
That does it - thanks very much.
On Apr 3, 6:36 pm, "Jim Cone" wrote: In an adjoining column use a formula similar to the one below and fill down. It assumes your data starts in cell B5... =COUNTIF($B$5:$B$50,B5) Now use auto filter and custom filter on those items that are < 1. Copy the list and paste where ever. -- Jim Cone San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) wrote in message How do I exclude all unique values from a column of data? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude Unique Values | Excel Worksheet Functions | |||
| How to average a column, but exclude zero AND negative values? | Excel Discussion (Misc queries) | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
| How do I search thr'o column and put unique values in differnt sheet and sum corresponding values in | Excel Programming | |||
Linear Mode
