| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dup check 2 columns - need it to delete correct one
Using Excel 2007, I have a two column list with over 100,000 rows.
Example: Jane Doe U Jane Doe John Doe John Doe U John Doe Jack Doe Jack Doe I want to run a dup check to make sure there is only one Jane, Jack or John Doe, but the copy I want to stay is the one with a U behind it if there is one (wouldn't matter which row is kept for Jack). From what I've done so far, the dup check simply keeps whichever record is in the top row. Seems like it should be an easy fix, but I'm lost. Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How Do I delete a check box. | New Users to Excel | |||
| delete a check box | Excel Discussion (Misc queries) | |||
| Check Box wont Delete | Excel Discussion (Misc queries) | |||
| How do I correct a cyclic redundancy check error | Excel Discussion (Misc queries) | |||
| How do I correct a cyclic redundancy check error | Excel Discussion (Misc queries) | |||
Threaded Mode
