Hello all,
I am a newbie here and have run into a problem that is a bit tough to crack.
From one sheet, I have about 70 numbers which I need to find on another sheet which has about 70,000 entries.
The sheet with 70,000 numbers can have the same number multiple times.
The end result I am looking for would be a filtered list with ONLY the multiple entries of the 70 numbers, derived from the 70,000 entry sheet.
I have been trying to use the Advanced filtering function but am getting nowhere. Please help!
Bookmarks