Let's assume the numbers to be in A1:A100
In B1 (insert ne column if needed - we can delete it alter)
=COUNT$A$1:$A$100,A1)
Copy down the column
Unique items will give result 1; duplicates will give 2, triplicates 3, etc
Sort on column B
Delete rows with B values 1
Delete column B
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Kevin Alcock" <Kevin
wrote in message
...
I've combined two lists of references from two worksheets and now want to
sort the new list to remove unique items and keep the duplicates. I'm
using
Excel 2003.