How to exclude unique values from a column?
 

How do I exclude all unique values from a column of data?

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?

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?