| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to find duplicates within same column
Hello all,
I am trying to find if there are any duplicate values within the same column, without removing them. Example ID no. 1121 2222 3343 5554 6785 4565 6785 1121 3343 In this example 1121, 3343, 6785 are duplicates. I have a ~20000 rows spreadsheet and would like to speed up the process. Thank you all, Frank |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I find duplicates in one column of an exel spreadsheet? | Excel Worksheet Functions | |||
| i need to find duplicates! ASAP | Excel Worksheet Functions | |||
| Find Duplicates | Excel Discussion (Misc queries) | |||
| Find duplicates and append | Excel Worksheet Functions | |||
| Find duplicates | Excel Discussion (Misc queries) | |||
Threaded Mode
