Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding and Isolating Duplicates
Hi,
I have a single column of numeric data that I want to search for duplicates. I know that I can use a "countif" statement with Conditional Formatting to highlight all the duplicates (e.g. ="COUNTIF(A$1:A$100, A1)1") but then is there a way to remove all of the remaining unique numbers or maybe using some sort of megaformula copy the highlighted cells along with any other data in that particular row to another spreadsheet? Thanks, Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding duplicates | Excel Discussion (Misc queries) | |||
Finding duplicates | Excel Discussion (Misc queries) | |||
Finding Duplicates | Excel Worksheet Functions | |||
Finding duplicates | Excel Worksheet Functions | |||
Finding Duplicates | Excel Worksheet Functions |