| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum duplicates unique values and delete dupliques | Excel Worksheet Functions | |||
| Array Formulas - Unique List from List with Duplicates | Excel Discussion (Misc queries) | |||
| How do I delete formulas but save numbers? | Excel Worksheet Functions | |||
| How can I create a list of random numbers with no duplicates? | Excel Discussion (Misc queries) | |||
| how to extract unique numbers once from a list of repeated numbers? | Excel Discussion (Misc queries) | |||
Hybrid Mode
