Match Excel lists?

January 26th, 2020

Hi Gurus!
I have tried to find help with this problem but with no luck.
I’m trying to get every row in list1 that have a match from list2 into a new list or sheet.
Easiest way is to give an example!
Image
I have actually done some loops in a macro, but there must be an easier way since it takes forever when dealing with lists 50000 rows long… or maybe it’s just my 90’s computer!
Greatful for any insight! (about the solution, not my computer)

Answer #1
You need to write some code. PM me and I’ll reply with a VBA macro for you.

 

| Sitemap |