| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i compare two text columns
Hi,
I have a workbook with two email columns. I want a function that checks if the email in column B matches the email in Column A to return the result (email) in Column C at the same row level it found it in Column A |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i compare two text columns
Hi,
Try =IF(COUNTIF(B$1:B$9,A1),A1,"") -- If this helps, please click the Yes button Cheers, Shane Devenshire "sflanegin" wrote: Hi, I have a workbook with two email columns. I want a function that checks if the email in column B matches the email in Column A to return the result (email) in Column C at the same row level it found it in Column A |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare text/numbers in different columns. | Excel Discussion (Misc queries) | |||
| how to compare text fields in 2 different columns in excel | Excel Worksheet Functions | |||
| how to compare 6 columns of text data | Excel Worksheet Functions | |||
| How do I compare 2 text columns & show differences in 3rd? | Excel Worksheet Functions | |||
| I have 2 columns to compare,each text. doing formulas, they don'. | Excel Worksheet Functions | |||
Linear Mode
