| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare two columns in same worksheet for similarities
I'm trying to compare column A to column B for similarities. Would like
similarities entered into column C. Can this be done? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
compare two columns in same worksheet for similarities
What do you define as similarities? Equality is easy to determine, but
similar can be pretty nebulous. Give us some examples of what you want to do. Regards, Fred. "Cynthia" wrote in message ... I'm trying to compare column A to column B for similarities. Would like similarities entered into column C. Can this be done? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
compare two columns in same worksheet for similarities
You can use the Exact function =exact(text1,text2) in column C and drag the
formula down the column. If it's similar, it returns TRUE, if not it says FALSE. You can then select the column, copy and "paste special" as values to do a Find for true. Or you can use the IF function in column D to copy the true values: =IF(C1=FALSE," ",B1). You can then copy and paste special as values the entire column D and then delete column C. "Fred Smith" wrote in message ... What do you define as similarities? Equality is easy to determine, but similar can be pretty nebulous. Give us some examples of what you want to do. Regards, Fred. "Cynthia" wrote in message ... I'm trying to compare column A to column B for similarities. Would like similarities entered into column C. Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare 2 worksheets all 6 columns in each worksheet | Excel Worksheet Functions | |||
| adding blank cells to multiple columns to show similarities | Excel Discussion (Misc queries) | |||
| compare two columns within a worksheet, then highlight duplicates | Excel Worksheet Functions | |||
| How many similarities is between excel and access | Excel Discussion (Misc queries) | |||
| How do I Compare worksheet columns | Excel Worksheet Functions | |||
Linear Mode
