Comparison of alphanumeric string

E

ErExcel

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 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.
 
A

Abhishek Jain

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
 
H

Héctor Miguel

hi, !

assuming start row:= 2

[C2] =countif(a:a,b2)>0

hth,
hector.

__ origina post __
 
E

ErExcel

Thanx a lot, Abhishek!!!!!!!!
It worked!!!!!!!!

Abhishek Jain said:
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
Click to expand...
 
E

ErExcel

Thanx a lot!!!!!
this too worked!!!!!!!!

Héctor Miguel said:
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.
Click to expand...
Click to expand...
 
Top