Find Matches from two columns with data that is in a different order

[Lauren_Holmes]

Hello, 

I am a little stuck. I need to try and match two columns from one file that contain the same information. However this information will be in a different order from each column. 

For example:

COLUMN 1:

123,ABC,456

COLUMN 2:

ABC,456,123 

These would be considered a "match" as they contain the same information. 

However if i had

COLUMN 1:

123,ABC,456

COLUMN 2:

456,ABC

This would be considered not a match as source 2 does not contain all the information. 

Any support and ideas would be really appreciated - I have attached an example file.

Thank you in advance 🙂 

[Qiu · Accepted solution]

@Lauren_Holmes 
Not so pretty one. 😁

[Lauren_Holmes]

This is great, thank you!

Exactly what i was after :)!