| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I delete 'fuzzy' duplicated rows?
I have approximately 45,000 entries that are a mix of text and numerics. I
need to set a formula, macro or something that will help me delete 'fuzzy'or non-identical rows that are duplicated. ie some rows have typos, or other similar mistakes. I can use the unique filter and other formulas to find identical cells but need to know how to find and delete the rows with odd characters in them. Please help! Thanks Ani |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete rows with duplicated values | Excel Discussion (Misc queries) | |||
| Delete rows with duplicated values | Excel Discussion (Misc queries) | |||
| How can I delete duplicated data | Excel Worksheet Functions | |||
| How to delete duplicated values in each row ??? | Excel Discussion (Misc queries) | |||
| Delete non duplicated rows | Excel Discussion (Misc queries) | |||
Threaded Mode
