How To Use Filter For Drop Down List In Google Sheet
How to filter data based on drop downward list in Google canvass?
Supposing, you accept a range of information in one sheet, and in another sheet, there is a drop-down list cell which is created based on the column Proper name of the first sheet. At present, y'all would similar to filter the corresponding information based on the selected item from the drop downwardly listing as following screenshot shown. How could yous solve this chore in Google sheet?
Filter information based on driblet-down list in Google canvass with formula
Filter information based on drop-down list in Google sheet with formula
Here, a formula tin help y'all to filter the respective information from a drop-downwards list pick, delight do as this:
1. Starting time, yous should insert a drop-down listing based on the name column equally below screenshot shown:
ii. In another new canvas, please enter this formula: =query(Sheet1!A1:D, " select * where C = '"&B1&"' " ) into a cell where you lot want to get the filtered result, run across screenshot:
Notation: In the above formula: Sheet1!A1:D is the original sheet proper noun and range cells you want to filter, C is the column number which contains the drop down items, B1 is the drop down list cell you lot want to filter based on.
iii. Then press Enter cardinal, all the matching rows from the drop-downward list selection have been extracted at once, see screenshot:
The Best Part Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by fourscore%
- Reuse: Chop-chop insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing Listing and ship emails...
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit big numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns without losing Data; Dissever Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Observe and Fuzzy Find in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Excerpt Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Betwixt Cells Content and Comments...
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/calendar week/day, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on cardinal columns; Dissever Information into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or system. Full features thirty-day free trial. 60-day money back guarantee.
Part Tab Brings Tabbed interface to Function, and Brand Your Work Much Easier
- Enable tabbed editing and reading in Discussion, Excel, PowerPoint , Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the aforementioned window, rather than in new windows.
- Increases your productivity by fifty%, and reduces hundreds of mouse clicks for you every twenty-four hour period!
How To Use Filter For Drop Down List In Google Sheet,
Source: https://www.extendoffice.com/documents/excel/4735-google-sheets-drop-down-filter.html
Posted by: dudleywainvis1959.blogspot.com
0 Response to "How To Use Filter For Drop Down List In Google Sheet"
Post a Comment