View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default How do I delete unique numbers from a list and save duplicates?

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.