Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determining if two columns values are equal/close
I have two columns of data as seen below:
ColA ColB 1 Acme Acme Inc. 2 XYZ ABC 3 Seal Seals I need to define in Col C whether or not data from col A and B are equal or close to being equal by using a True/False result. For example, row 1 and 3 would be a match. However row 2 would not. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determining if two columns values are equal/close
Hi
In column C =ISNUMBER(FIND(A1,B1)) will return True for rows 1 and 3 FIND is case sensitive. If you are not concerned about case then use the non case sensitive Search function =ISNUMBER(SEARCH(A1,B1)) -- Regards Roger Govier "GDCross" wrote in message ... I have two columns of data as seen below: ColA ColB 1 Acme Acme Inc. 2 XYZ ABC 3 Seal Seals I need to define in Col C whether or not data from col A and B are equal or close to being equal by using a True/False result. For example, row 1 and 3 would be a match. However row 2 would not. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determining if two columns values are equal/close
That helps Roger. Any insight into row 4's predicament as I want it to return
a true value but the formulas below return a false value. Thanks for your help. ColA ColB 1 Acme Acme Inc. 2 XYZ ABC 3 Seal Seals 4 Seals Seal "Roger Govier" wrote: Hi In column C =ISNUMBER(FIND(A1,B1)) will return True for rows 1 and 3 FIND is case sensitive. If you are not concerned about case then use the non case sensitive Search function =ISNUMBER(SEARCH(A1,B1)) -- Regards Roger Govier "GDCross" wrote in message ... I have two columns of data as seen below: ColA ColB 1 Acme Acme Inc. 2 XYZ ABC 3 Seal Seals I need to define in Col C whether or not data from col A and B are equal or close to being equal by using a True/False result. For example, row 1 and 3 would be a match. However row 2 would not. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determining if two columns values are equal/close
maybe
=OR(ISNUMBER(FIND(G25,H25)),ISNUMBER(FIND(H25,G25) )) "GDCross" wrote: I have two columns of data as seen below: ColA ColB 1 Acme Acme Inc. 2 XYZ ABC 3 Seal Seals I need to define in Col C whether or not data from col A and B are equal or close to being equal by using a True/False result. For example, row 1 and 3 would be a match. However row 2 would not. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determining if two columns values are equal/close
I used
=IF(AND(TEXT(ISNUMBER(SEARCH(A2,B2)),0)="false", TEXT(ISNUMBER(SEARCH(B2,A2)),0)="false"),"FALSE", "TRUE") and it seems to work. Thanks Roger and Mike for your assistance and have a blessed day. "GDCross" wrote: That helps Roger. Any insight into row 4's predicament as I want it to return a true value but the formulas below return a false value. Thanks for your help. ColA ColB 1 Acme Acme Inc. 2 XYZ ABC 3 Seal Seals 4 Seals Seal "Roger Govier" wrote: Hi In column C =ISNUMBER(FIND(A1,B1)) will return True for rows 1 and 3 FIND is case sensitive. If you are not concerned about case then use the non case sensitive Search function =ISNUMBER(SEARCH(A1,B1)) -- Regards Roger Govier "GDCross" wrote in message ... I have two columns of data as seen below: ColA ColB 1 Acme Acme Inc. 2 XYZ ABC 3 Seal Seals I need to define in Col C whether or not data from col A and B are equal or close to being equal by using a True/False result. For example, row 1 and 3 would be a match. However row 2 would not. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using SUMPRODUCT to count values in separate columns | Excel Worksheet Functions | |||
Formula to count values in two columns | Excel Discussion (Misc queries) | |||
Looking-up Columns w/calc'd Values ONLY to Calculate Average | Excel Worksheet Functions | |||
Multipying columns that contail null values | Excel Discussion (Misc queries) | |||
Totalling values across columns | Excel Worksheet Functions |