Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula to exclude all data except multiple entries?
I have about 11,000 documents listed in a worksheet that are individually
numbered, and want find duplicate entries in the worksheet. I need to create a formula that will allow me to see ONLY the duplicates. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula to exclude all data except multiple entries?
If this is something you have to do regularly, I would recommend Jim Cone's
fine commercial Add-in called XLCompanion. It's available at http://www.realezsites.com Vaya con Dios, Chuck, CABGx3 "cd_gilbert" wrote: I have about 11,000 documents listed in a worksheet that are individually numbered, and want find duplicate entries in the worksheet. I need to create a formula that will allow me to see ONLY the duplicates. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula to exclude all data except multiple entries?
Here's one way.
Let's say your data is in A1:A11000, with headers in row 1 1. Sort your data by column A (ascending) 2. Place the formula "=COUNTIF($A2:$A$11000,A2)=1" in cell B1 and fill down 3. Sort your data by column B 4. You can delete all the rows that say "FALSE" in column B, those are the dupes I tested this on a small sample and it worked well. Remember you must sort ascending first otherwise you can miss out on some dupes. HTH, JP On Dec 13, 1:37 pm, cd_gilbert wrote: I have about 11,000 documents listed in a worksheet that are individually numbered, and want find duplicate entries in the worksheet. I need to create a formula that will allow me to see ONLY the duplicates. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula to exclude all data except multiple entries?
Sorry that should read "Place the formula "=COUNTIF($A2:$A
$11000,A2)=1" in cell B2 and fill down" Thx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine Multiple Entries with differing amounts of entries | Excel Worksheet Functions | |||
exclude data already imported in excel | Excel Discussion (Misc queries) | |||
How do I group multiple data entries in sub-groups | Excel Worksheet Functions | |||
how to exclude data outliers from formula or chart without deleti. | Excel Discussion (Misc queries) | |||
Filtering a column to exclude any repeated entries. | Excel Discussion (Misc queries) |