QUERY - Drop Down List to Filter Data - Google Sheets

Learn how to use QUERY function with drop down validation lists to get dynamically filterer results of of a data-set in Google Sheets.

#googlesheets #dropdown #tutorial

[shawnieleaf]

Dude your videos have been THE ONLY VIDEOS that have actually made sense, allowed me to do what I needed and actually get my project done. THANK YOU!!

[agneserinkim]

thank you so much for breaking down this mysterious language of spread sheet filtering. you're really good at this!!!

[nanditapandey]

Thank you so much. You make videos in the simplest possible way where all of us can understand. I have started to enjoy working on Gsheets using your method of learning.

[marksawesomeadventures]

Thanks a lot, I was beating my brains out for like a Week trying to figure something out, some way to Search, I tried creating a Search Box, but nothing was working right, I simplified your ideas by just focusing on ONE Drop Down List, and no Sort, No ALL reps, just as basic as I could make it, and it worked! I finally was able to use this to Sort through an Inventory of 1500 items, and the Beauty of this method is it will actually list the item if it is located in two or three different places which helps to organize the Warehouse. And I was able to figure out how to use Google Sheets App to even look things up on my Cellphone. So you really helped me out a lot with this Video! Thanks again!

[JMPatel-nkgr]

How do you know what i want next in google sheet, 😍 U r reading my mind...

[kingfratetrain]

I was figuring this out for 3 hours and this vid finally got me to where i needed to go.

[MaximeDUPONTmypage]

Thank you very much. You are doing a wonderfull job at explaining so clearly all these tips, tricks and how tos... bravo !
Looking at this video, may i ask : "how would you build the query formula if the dropdown menus are replaced by check boxes" ? Maybe an idea for another video subject... Thank you et, again, great job. I love your channel !!

[mdrob]

You deserve a like and commnet, it was almost exactly what i needed, i have to make a few adjustments, buti learned something new and more importantly solved my problem. Thank you.

[brook]

You made my day. All the data were well filtered. It was very easy to get information of my Company much quicker!!

[neilvanrooyen]

"Whatever that little thing is"... It's basically a Table/Grid/Cells, ie, Your "Range" Selector. You're welcome. Great Video by the way.

[cplbqkq]

This is really easy to follow and understand the process. Thank you very much for sharing

[williamland]

Holy crap man your videos helped me so much tonight! I almost can't believe I learned as much as I did. Thank you!

[zubeirmsemo]

Thanks!!! Really helped me gaining an internship

[DanSaleem]

Thank you so much. Your channel is amazing. I have one problem when using Query function. I have a table that includes grade levels for a classroom, 1, 2, 3, and I have grade "K" for kindergarten. When I use query formula it does only show grades with numbers and omit the letter K for kindergarten. Is there a way to have the pull both text and numbers from the column using query?

[MinhTran-ixic]

thanks man very much, your step-by-step instruction is super helpful

[HoldenMachining]

"1=1" that's what I needed. Well worth watching the video!

[MonjiGhanem]

Wonderful presenting!!
Thank youvery much 👍

[willsgrandad]

Thanks for uploading, I have been looking at your Google sheets Query video's. I had worked out how to do a query from a drop down list, but yours is much tidier than mine. Keep up the good work.

[vicentepbsaraiva]

Excellent tutorial. Very detailed and easy to replicate. Thank you.

[roweey]

Hi! You've been a great help learning advanced sheets functions! I was able to do this using multiple dropdowns, and importrange as well. I have a question, though. How do you hide all the data (source file) when the dropdown is blank?