Comparing text lists.
Help – been up all night and brain is flat…
I have a text list, which I need to compare with n-amount of other lists. IE:
Original list: “beer, whisky, wine, vodka, tequila”
Then I have:
List 2: “beer, chocolate, nuts”
List 3: “whisky, bacon, beer”
List 4: “chocolate, bacon”
Etc…
I need a script that compares my original list with list 2, 3 & n, and return the list number that matches ANY of the list elements. IE my result set would be “2, 3”. (the ID of the lists returned as a valuelist)
Bonus point if you can arrange them by the amount of matches – “3, 2” – but non-essential.
Point me in the right direction please!
