Jun 19 2019 09:04 AM
Hello excel tech community! I was wondering if anyone knew of a way to filter a large list (with 25k plus rows) with another long list (1500 plus rows). I have a list of names that I need to cross reference with a database of names to find overlapping data. The overlaps are a good thing in this scenario, so I was wondering what would be the easiest way to accomplish/automate this?
Thanks!
Jun 19 2019 09:33 AM
That could be Advanced Filter, the idea is here https://contexturesblog.com/archives/2017/05/18/excel-filter-to-match-list-of-items/