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?
|