How to exclude unique values from a column?

[wrethams]

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

 

[Michael]

From the Main Menu, select:
Data->Filter->Advanced Filter
and follow the instructions, just make sure you check the box that reads
Unique Records Only.

 

[wrethams]

Hi - I tried this but it doesn't seem to work - it shows all the items
in the list, omitting any duplicates.

I want the opposite.

Thanks

 

[Jim Cone]

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)


<[email protected]>
wrote in message
How do I exclude all unique values from a column of data?

 

[wrethams]

That does it - thanks very much.