| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing two Non- Identical Columns of Data
I dont know if its possible via a formula in a third column, but I would like
to have a formula comparing Column 1 to column 2 to determine if the data after the 'comma' in both columns are identical. Just not sure how... Column 1 Column 2 Managing Director, Finance MD, Finance Senior Vice President, Operations SVP, Operations Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comparing two Non- Identical Columns of Data
try
=IF(RIGHT(C14,LEN(C14)-FIND(",",C14))=RIGHT(D14,LEN(D14)-FIND(",",D14)),"match","") -- Don Guillett Microsoft MVP Excel SalesAid Software "RBG" wrote in message ... I dont know if its possible via a formula in a third column, but I would like to have a formula comparing Column 1 to column 2 to determine if the data after the 'comma' in both columns are identical. Just not sure how... Column 1 Column 2 Managing Director, Finance MD, Finance Senior Vice President, Operations SVP, Operations Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comparing two Non- Identical Columns of Data
works great...thanks.....
"Don Guillett" wrote: try =IF(RIGHT(C14,LEN(C14)-FIND(",",C14))=RIGHT(D14,LEN(D14)-FIND(",",D14)),"match","") -- Don Guillett Microsoft MVP Excel SalesAid Software "RBG" wrote in message ... I dont know if its possible via a formula in a third column, but I would like to have a formula comparing Column 1 to column 2 to determine if the data after the 'comma' in both columns are identical. Just not sure how... Column 1 Column 2 Managing Director, Finance MD, Finance Senior Vice President, Operations SVP, Operations Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing columns of data | Excel Discussion (Misc queries) | |||
| Comparing 2 columns of data | New Users to Excel | |||
| Comparing two List that a "Close" but not Identical | Excel Worksheet Functions | |||
| Comparing Data in 2 columns | Excel Worksheet Functions | |||
| Comparing Data in two columns | Excel Worksheet Functions | |||
Linear Mode
