| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Duplicates; How can I get a list of items removed?
Its good to remove the duplicates. However, I would lilke to get a list of
the duplicates that were removed. How can I get this list? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove Duplicates; How can I get a list of items removed?
Use the original list and then compare them with a simple is formula
appended to the original list, so if the original list is in A2:A500, then insert temporarily a blank B column or use the one that exists if it is empty, assume the list w/o duplicates are in Sheet2!A2:A480 =COUNTIF(Sheet2!$A$2:$A$480,A2)1 copy down the formula, then apply datafilterautofilter (make sure you have headers) and filter on B for TRUE, then just copy the filtered list somewhere else, that is the list with duplicates -- Regards, Peo Sjoblom "Kjenkins" wrote in message ... Its good to remove the duplicates. However, I would lilke to get a list of the duplicates that were removed. How can I get this list? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove Duplicates; How can I get a list of items removed?
Post a sample of your data
"Kjenkins" wrote: Its good to remove the duplicates. However, I would lilke to get a list of the duplicates that were removed. How can I get this list? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I SORT A COLUMN OF NUMBERS AND HAVE THE DUPLICATES REMOVED | Excel Discussion (Misc queries) | |||
| Remove duplicates | Excel Discussion (Misc queries) | |||
| How to remove duplicates from a list and copy new list to new colu | Excel Worksheet Functions | |||
| Transfer Items to a list with no duplicates | Excel Worksheet Functions | |||
| How do I remove items listed in a pivot table drop down list box | Excel Discussion (Misc queries) | |||
Hybrid Mode
