Compare two strings

Looking for a line of code or formula to check if two strings have the same characters but not necessarily in the same order (without using a loop or sorting the strings)

e.g.

ABCDE
BEADC

should result in a match

Thanks

Hi

Assumes that your data is in A1:A2, and you only have 5 characters in the string. If you have a variable number, then let us know.

=AND(ISNUMBER(SEARCH(MID(A1,ROW(A1:A5),1),A2))) (array entered).

HTH

rylo

Hi

So there are a few more things to consider.

1) if the strings are not the same length, then is that an automatic fail?
2) if there are repeats is that an automatic fail?
3) is this a one way compare, or both way (ie are you comparing all the items in A1 with A2, or does A2 also have to work with A1)

are there any more things to consider?

rylo

rylo

It should be a 100% identical match (character for character) except that the characters do not have to be in the same order. So yes the length of the string should be the same

Also the characters could be numeric

ABCDE & BDCAE ==> YES
AACDE & BDCAE ==> NO
1234 & 3412 ==> YES

Thanks

Still waiting for a solution....

Hi

This does seem to be extremely cumbersome, but I think it does get you there. Array entered of course.

Please Login or Register  to view this content.

rylo

Hi

Of course, just put in the relevant cell references as required.

rylo