Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparison of alphanumeric string
Hi,
I want to comapre alphanumeric string in two different columns irrespective of sequence. Ex: Column A Column B Expected Result ABCD1234 PQRS3456 TRUE PQRS3456 IJKL456 FALSE WXYZ6789 EFGH5678 TRUE EFGH5678 MNOP2345 FALSE I need formula which will compare strings in column A and column B and if the values are matching it should display as true otherwise false. One value of cells needs to be searched or compared with all cells of other column irrespective of sequence. If possible formula should not be case sensitive. There will be addition, deletion of members. I tried following two furmula: Following 2 formulas can be used: OR(EXACT(TestValue, CompareRange)) EXACT(B2,C2) but it does not provide proper result incase strings are not in sequence. Thanking you in anticipation. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparison of alphanumeric string
Hi Dear,
Pl try these formula........(Formula is in raw form pl make it real in your case) 1. =IF(C7=(VLOOKUP(C7,E4:E7,1,0)),"true","false") 2. =IF(ISERROR(VLOOKUP(C8,E5:E8,1,0)),"FALSE","TRUE") Regards Abhishek Jain "ErExcel" wrote: Hi, I want to comapre alphanumeric string in two different columns irrespective of sequence. Ex: Column A Column B Expected Result ABCD1234 PQRS3456 TRUE PQRS3456 IJKL456 FALSE WXYZ6789 EFGH5678 TRUE EFGH5678 MNOP2345 FALSE I need formula which will compare strings in column A and column B and if the values are matching it should display as true otherwise false. One value of cells needs to be searched or compared with all cells of other column irrespective of sequence. If possible formula should not be case sensitive. There will be addition, deletion of members. I tried following two furmula: Following 2 formulas can be used: OR(EXACT(TestValue, CompareRange)) EXACT(B2,C2) but it does not provide proper result incase strings are not in sequence. Thanking you in anticipation. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparison of alphanumeric string
hi, !
assuming start row:= 2 [C2] =countif(a:a,b2)0 hth, hector. __ origina post __ I want to comapre alphanumeric string in two different columns irrespective of sequence. Ex: Column A Column B Expected Result ABCD1234 PQRS3456 TRUE PQRS3456 IJKL456 FALSE WXYZ6789 EFGH5678 TRUE EFGH5678 MNOP2345 FALSE I need formula which will compare strings in column A and column B and if the values are matching it should display as true otherwise false. One value of cells needs to be searched or compared with all cells of other column irrespective of sequence. If possible formula should not be case sensitive. There will be addition, deletion of members... I tried following two furmula: Following 2 formula's can be used: OR(EXACT(TestValue, CompareRange)) EXACT(B2,C2) but it does not provide proper result incase strings are not in sequence. Thanking you in anticipation. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparison of alphanumeric string
Thanx a lot, Abhishek!!!!!!!!
It worked!!!!!!!! "Abhishek Jain" wrote: Hi Dear, Pl try these formula........(Formula is in raw form pl make it real in your case) 1. =IF(C7=(VLOOKUP(C7,E4:E7,1,0)),"true","false") 2. =IF(ISERROR(VLOOKUP(C8,E5:E8,1,0)),"FALSE","TRUE") Regards Abhishek Jain "ErExcel" wrote: Hi, I want to comapre alphanumeric string in two different columns irrespective of sequence. Ex: Column A Column B Expected Result ABCD1234 PQRS3456 TRUE PQRS3456 IJKL456 FALSE WXYZ6789 EFGH5678 TRUE EFGH5678 MNOP2345 FALSE I need formula which will compare strings in column A and column B and if the values are matching it should display as true otherwise false. One value of cells needs to be searched or compared with all cells of other column irrespective of sequence. If possible formula should not be case sensitive. There will be addition, deletion of members. I tried following two furmula: Following 2 formulas can be used: OR(EXACT(TestValue, CompareRange)) EXACT(B2,C2) but it does not provide proper result incase strings are not in sequence. Thanking you in anticipation. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparison of alphanumeric string
Thanx a lot!!!!!
this too worked!!!!!!!! "Héctor Miguel" wrote: hi, ! assuming start row:= 2 [C2] =countif(a:a,b2)0 hth, hector. __ origina post __ I want to comapre alphanumeric string in two different columns irrespective of sequence. Ex: Column A Column B Expected Result ABCD1234 PQRS3456 TRUE PQRS3456 IJKL456 FALSE WXYZ6789 EFGH5678 TRUE EFGH5678 MNOP2345 FALSE I need formula which will compare strings in column A and column B and if the values are matching it should display as true otherwise false. One value of cells needs to be searched or compared with all cells of other column irrespective of sequence. If possible formula should not be case sensitive. There will be addition, deletion of members... I tried following two furmula: Following 2 formula's can be used: OR(EXACT(TestValue, CompareRange)) EXACT(B2,C2) but it does not provide proper result incase strings are not in sequence. Thanking you in anticipation. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
random alphanumeric string | Excel Worksheet Functions | |||
How to extract decimal numbers e.g. $1.57 from alphanumeric string | Excel Discussion (Misc queries) | |||
How do I replace last numeric string from a alphanumeric string? | Excel Discussion (Misc queries) | |||
Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions | |||
Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions |