Hi,
we have a bunch of strings comprising of characters "A","B"..."Z" (and no others). A typical string looks like <CODE>ABZYC</CODE>. The strings are given in pairs like <CODE>ABC</CODE>, <CODE>ABDC</CODE>.
The strings are match if one string is contained in the other (i.e either one of the two strings contain all the alphabets of the other). The order in which the string appears don't matter.
so, is there a formula way of doing that, or is it VBA only?
thanks
Philip
PS - I did something in VBA, but wondered if there was a lovely formula solution?
we have a bunch of strings comprising of characters "A","B"..."Z" (and no others). A typical string looks like <CODE>ABZYC</CODE>. The strings are given in pairs like <CODE>ABC</CODE>, <CODE>ABDC</CODE>.
The strings are match if one string is contained in the other (i.e either one of the two strings contain all the alphabets of the other). The order in which the string appears don't matter.
Code:
[FONT=Courier New]ACBD[/FONT],<CODE>AC</CODE> - <CODE>Match</CODE>
<CODE>ACBD</CODE>,<CODE>CA</CODE> - <CODE>Match</CODE>
<CODE>ACBD</CODE>,<CODE>ADB</CODE> - <CODE>Match</CODE>
<CODE>AC</CODE>,<CODE>ABCD</CODE> - <CODE>Match</CODE>
<CODE>ABC</CODE>, <CODE>ABD</CODE> - <CODE>No Match</CODE>
so, is there a formula way of doing that, or is it VBA only?
thanks
Philip
PS - I did something in VBA, but wondered if there was a lovely formula solution?
Last edited: