Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare part of a cell to a column
I have 2 lists that need to be compared. They have the same info, but
slightly different. For instance, one of them has "Mr. Bob Smith" in one cell. The other list just has "Bob Smith". I need to compare the 2 columns and delete or mark the duplicates. So basically I need to compare part of each cell in the column on the first sheet to a cell in a column in the second sheet. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare part of a cell to a column
OK, I figured out the text to column thing :)
Not what is the easiest way to do a comparison between 2 spreadsheets that do not have identical data? One has email addresses and one just had regular addresses, along with the names, so I just want to compare names and get duplicates. "JessicaZ" wrote: I have 2 lists that need to be compared. They have the same info, but slightly different. For instance, one of them has "Mr. Bob Smith" in one cell. The other list just has "Bob Smith". I need to compare the 2 columns and delete or mark the duplicates. So basically I need to compare part of each cell in the column on the first sheet to a cell in a column in the second sheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions |