| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Deleting Duplicates
I have a hugh file (10,000 entries) and am trying to wean out the duplicates.
I inserted a column and ran If(B1=B2,"DUP",""). However, it's still time consuming to delete all the duplicates. Is there a way that I could # the duplicates (each dupl is #2)and just put in some formula to delete all the 2's. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find duplicate rows then deleting them | Excel Worksheet Functions | |||
| Deleting the first row of two duplicates. | Excel Discussion (Misc queries) | |||
| Duplicates - deleting to get just unique ones | New Users to Excel | |||
| Deleting ALL duplicates using Pearson's code | Excel Worksheet Functions | |||
| Finding and Deleting duplicates in a column | Excel Worksheet Functions | |||
Threaded Mode
