Home

Filtering one large data sheet (25k + rows) with another long list (1500+ rows)

%3CLINGO-SUB%20id%3D%22lingo-sub-707624%22%20slang%3D%22en-US%22%3EFiltering%20one%20large%20data%20sheet%20(25k%20%2B%20rows)%20with%20another%20long%20list%20(1500%2B%20rows)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-707624%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20excel%20tech%20community!%20I%20was%20wondering%20if%20anyone%20knew%20of%20a%20way%20to%20filter%20a%20large%20list%20(with%2025k%20plus%20rows)%20with%20another%20long%20list%20(1500%20plus%20rows).%20I%20have%20a%20list%20of%20names%20that%20I%20need%20to%20cross%20reference%20with%20a%20database%20of%20names%20to%20find%20overlapping%20data.%20The%20overlaps%20are%20a%20good%20thing%20in%20this%20scenario%2C%20so%20I%20was%20wondering%20what%20would%20be%20the%20easiest%20way%20to%20accomplish%2Fautomate%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-707624%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-707721%22%20slang%3D%22en-US%22%3ERe%3A%20Filtering%20one%20large%20data%20sheet%20(25k%20%2B%20rows)%20with%20another%20long%20list%20(1500%2B%20rows)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-707721%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F363029%22%20target%3D%22_blank%22%3E%40Drew99%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%20Advanced%20Filter%2C%20the%20idea%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcontexturesblog.com%2Farchives%2F2017%2F05%2F18%2Fexcel-filter-to-match-list-of-items%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcontexturesblog.com%2Farchives%2F2017%2F05%2F18%2Fexcel-filter-to-match-list-of-items%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Drew99
Occasional Visitor

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!

1 Reply
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies