Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identify Duplicates that are not identical
I have two spreadsheets that contain duplicate names of idividuals. One
spreadsheet includes the first name in column "A" and the last name in column "B". The other spreadsheet contains the entire first and last name in column "A" in the format; "Lastname, Firstname". Is there a way for me to identify (not eliminate) these duplicates even though they are not identical? Thanks, KFM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
identify cells containing identical values in two columns | Excel Discussion (Misc queries) | |||
Identify Duplicates in a List | Excel Discussion (Misc queries) | |||
Counting almost identical duplicates | Excel Discussion (Misc queries) | |||
identify duplicates and sum corresponding values | Excel Worksheet Functions | |||
identify duplicates | Excel Discussion (Misc queries) |