I have two lists that I need to match against each other. I have a list of projects that can have a carriage return limited list of locations, such as
I have a filter that people can check where they can choose PDX only or NY and LA or LA and PDX. I need to constrain my previous find (from another criteria) to show the records that have any of the selected locations. I am looping through the records, but for the love of... I can't match the lists properly. PatternCount gives me partial matches. If I choose LA and NY, it won't give me the record that has NY and PDX in it, but it's also not even totally consistent.
I also tried Agnes Barouh's custom function FilterList, but that gives me an error about the attribute, which I have in quotes and caps.
Any ideas out there?
Thanks in advance,