Home

Advanced Filters Based on Cell Value Input

%3CLINGO-SUB%20id%3D%22lingo-sub-299323%22%20slang%3D%22en-US%22%3EAdvanced%20Filters%20Based%20on%20Cell%20Value%20Input%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299323%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20database%20(9x6000)%20with%20approximately%206000%20rows%20of%20text%20characters%20and%20numbers.%20These%20columns%20are%20currently%20filtered%20and%20an%20easy%20way%20to%20narrow%20the%20columns%20with%20numbers%20in%20them%20is%20to%20right-click%20on%20the%20filter%20button%20and%20search%20for%20%22between%22%20two%20numbers%20(like%20it%20says%20here%20in%20this%20website%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Ffilter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c37dcc180e%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Ffilter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c37dcc180e%3C%2FA%3E).%20I%20was%20wondering%20if%20anyone%20knew%20of%20a%20way%20to%20do%20this%20quickly%20by%20entering%20numbers%20in%20to%20two%20different%20cells%20to%20make%20it%20a%20more%20expedited%20process.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EScott%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-299323%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
scott_M7
Occasional Visitor

I have a database (9x6000) with approximately 6000 rows of text characters and numbers. These columns are currently filtered and an easy way to narrow the columns with numbers in them is to right-click on the filter button and search for "between" two numbers (like it says here in this website https://support.office.com/en-us/article/filter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c...). I was wondering if anyone knew of a way to do this quickly by entering numbers in to two different cells to make it a more expedited process.

 

Please help.

 

Thank you,

 

Scott

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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies