Google Sheets QUERY Function Tutorial - SELECT, WHERE, LIKE, AND, OR, LIMIT statements - Part 1

Video tutorial series about QUERY function in Google Sheets.
In this tutorial we'll cover how to use QUERY function in Google Sheets to pull filtered results out of your main dataset. We'll use SELECT, WHERE, LIKE, AND, OR and LIMIT statements to filter data by number value, text & text that contains a certain string in it.
Google Sheets
www.google.com/sheets/about/
Website:
www.chicagocomputerclasses.com/

[@mercadoboricua6154]

EXCELLENT VIDEO THIS IS EXACTLY WHAT I NEED!!! Now I understand more the power of GSheets, I enjoy 19:29 minutes, super simple and straight forward. Super valuable, I love it! This is one of this video that I saved in my own private playlist. Query functions are amazing! Thanks!

[@sethhill7573]

Amazing! I just built a query from client data to show the client, their preferences, and plan type for clients who are either recent starts or restarts so my team can give extra attention to our newbies. Thank you!

[@ALLGAMELOEBA]

After 2 weeks of searching, this is exactly what I wanted! Thanks so much!!!

[@rotrose7531]

I love your tutorial very much, you are so good at it, and always trying something no one else ever thought of. Very stimulating experience. Thank you

[@nyinyilin2380]

me too. Thanks U so much for sharing

[@adaml223]

Wow, this is game changing for me. Love the video. Thank you.

[@StefanoVerugi]

thanks, best video series on this topic so far, very helpful

[@Javicrack16]

Agreed !

[@alexandremoraesmatos]

Your videos are great! I'm learning so much. Thanks a lot.

[@jordansmith1045]

I've watched hours and hours of your videos. Thanks for sharing!

[@the_feature_selector859]

Good video! I usually open the same spreadsheet in two browser tabs as easier to switch between (shift-tab), rather than using Google sheets tabs.

[@ERGODINHO]

+- 13:00 limit results to... Very helpful!!! Thanks

[@hirenkakkad6855]

I really appreciate all of your videos. I learn lot many things from it. Wherever I stuck, I refer your videos. Please keep posting this kind of knowledge. Thanks

[@stmsolution]

If you want to watch more video about Google sheets, look on my channel STM Solution, i have many videos what you will like.

[@jj342]

Your videos are absolutely amazing. They have saved me so much time and aggravation because you explain it so clearly!

[@hyper-focus1693]

I completely agree. I'm so grateful for that guy. He made everything I was looking for easy to understand. Also, super creative in combining functions, scripts, & the likes.

[@juantelle1]

THANK YOUUUUUUUUUUUU THIS IS EXACTLY WHAT I WAS LOOKING FOR

[@67Keldar]

Awesome.... very clearly presented.... had no idea this functionality was even available in Google Sheets. Many Thanks

[@ericlengefeld8442]

Looking forward to part 2. Thank you.

[@muhannadothman2395]

Thanks a lot, very very helpful and comprehensive video for relevant topic

[@TeSageDS]

Thank you so much for detailed tutorial video. You saved my time. I will tweet about it

[@JanJanuszNosacz]

Awesome tutorial. Helped me understand Queries, thank you!

[@hoiyinwan8233]

Thank you, these videos are so useful! ❤️💖

[@alansavage3549]

Great tutorial. Going help me a lot making good use of google sheets in my work flow. Thanks.

[@vaibhavoswal5590]

Love your Content; You're just amazing Keep up the good work

[@dinoo82]

GREAT TUTORIAL! Super helpful! Easy to follow and is exactly what I was looking for.

[@ExcelGoogleSheets]

Great to hear!

[@dreamwalker9283]

I want you to know that you are the best at what you do!

[@michaeloliveras7469]

Thank you, it make my work a lot easier

[@walbervalente5581]

Powerful tools! Thank you so much, bro.

[@daytodatainc.2520]

Another great video! Thank you

[@InspiringThings101]

Always a great teacher!!

[@vincentjbr]

these explanations are very clear, thank you very much

[@InspiringThings101]

YOU SIR, Are a Genius!!!!! Thank You!

[@fabiomazzei9871]

Muito bom! Parabens pelo conteudo. Very good video! Very helpful. Congrats for share this content.

[@jhunmangalino1349]

Thanks for this video... VERY VERY VERY HELPFUL !!!

[@claystudiofx]

One of the best channel for learning google sheet.

[@noodle9245]

Thanks for the video. You saved me lots of trouble.

[@rajkumarjohi2776]

very clear and concise, thankyou

[@taimurahmad1455]

Excellent Work. You made my system way better with this Tutorial. Best of Luck

[@carlosanaya2889]

Excellent way to explain things. You made my day..Wish you the best.

[@nguyenduclong93]

Your videos are amazing and they helped me a lot. Thank you so much!!!

[@ExcelGoogleSheets]

Glad you like them!

[@edmarrobertoprandini6062]

Very good your explanation. Thanks. But, and if I need include one calculated field like after select two fields (string, number) then I need calculate the % of each numbered register by sum of results? (select A,B where "one condition" and include field (as '%') using B/sum(B)) How can I do it?

[@osherezra131]

hey man, great stuff I'm trying to find an answer for and issue: how can you make updates on the referenced table (table with the query) without breaking it? or different approach to make a separate column outside of the query, but to keep inline with the other rows. because currently when the query is updated the rows don't match on the new column that been made hope I'm clear cheers :)

[@adydick]

Great video, thank you!

[@HeliosZA]

Just a suggestion. Maybe share your data sheet in the about section so that people can follow along using the queries. Great video!

[@2000sunsunny]

so clear so net . thank you for this post

[@eugenesoft856]

Extremely Excellent !

[@gabbyuym1]

Great tutorial. In this video, you have a 2nd spreadsheet called "Query Language Reference". How do you generate that file. It would be very handy to have that as a quick reference as you have done. Thanks.

[@hbasumatary1995]

Thank you so much for the lesson

[@prameshkumar3364]

This is the best video for Query Function. But it would be great if u provide the google sheet the same for practice.

[@davidrajkumar4896]

Is it possible to create hyperlinks to the query results that takes me back to the original location of certain data.

[@MuhammadIbrahim-zc1vx]

You used YEAR function to extract corresponding year from Column A. If we don't do that and manually type year as text, the query function recognizes the year data as text and we can use single ' ' to define the text after where statement? (5:40)

[@officeoffamilyandcommunity2918]

Thank You +Learn Google Spreadsheets for this series!

[@eunicefua2559]

This is a very helpful video indeed. Is there a limit with how many times I can use the command "AND"?

[@vernoncheung685]

I couldn't figure out why my reference dates were not pulling through correctly and I just forgot to add the parentheses 🤦🤦. You sir are a life saver🤗

[@Wizardofoz1981]

Thank you. 19:29 I relly need this

[@chrislopez9665]

Thank you so much great video!

[@walterpaiva719]

Really good video

[@yuyang0729]

Thanks. Learn a lot.

[@mikecarney8023]

Is there a way to label columns that are aggregated using "Label" in the query statement?

[@divyavanibodakunta1860]

Thank you so much... your videos are very helpful to me.. I learnt alot..

[@IvanOung]

Thank you so much!

[@Gamesofmach]

Hello there I have formula in on column. and want to aplyy it to all other neighborhood columns. how i can do it?? by clicking and moving it to all othersdoesnt work because it changes cells in formula in wrong way

[@CroresPlanners]

Thank you so much for the video. Its so useful to us.

[@markmccoy2856]

GREAT DESCRIPTIONS!

[@ormzkie03]

very helpful thanks for the tuts

[@noliremacha1542]

thank you very much, I only have one inquiry can the query function be use when the data is continuously updating, I mean i have a data entry and it keeps populating everytime. thanks again

[@rashidanwar7831]

Yes you can Noli, but just keep the range open like if you are querying some range , for example instead of =QUERY(sheet1!A1:G40, use =QUERY(sheet1!A1:G So don't mention the row number and just keep the last column name. This will make your query function dynamic.

[@nomadicperceptions]

Great video, as always! I have a problem, I don't understand the difference between query and array, to me looks like you can achieve the same results using one or another. I'm sure I'm missing something though...😅 Thanks for the great resources!

[@user-xx7pm6dp1i]

Крутое видео! Cool tutorial

[@netboy1102]

Helps alot, thanx

[@feeldazzling272]

Thank you soooooo much, life saver :)

[@kennywiseman3932]

how can i select mismatch between two columns? for example how do i get all data in column A that is not found in column B?

[@AnyPossibleRandomThing]

I'm binging your vidoes right now. Very helpful and easy to understand!

[@ExcelGoogleSheets]

:)

[@alistairschwab1363]

finally gets started one minute into video

[@armandazharan5739]

Thanks man!

[@davideluwah1730]

Your videos are amazing and they helped me a lot. please can we get a copy of the excel sheet for practice? Thank you so much!!

[@sharif7351]

Excellent!

[@Sulaimangalib]

You are the best!!!

[@leandrobaptista6860]

Excellente! Tks

[@murbacchiu]

First of all Happy new 2018 and congrats for your amazing job . Contents you are sharing are amazing. I have one question. Is it possible to merge two different google sheets according one specific criteria? For example I have one module collecting name of project and another module collecting other information with the same name of project. I would like to create with query function a new sheets with using Name of Project as criteria of sorting. Thanks

[@md.abdulmalek7047]

very helpful tutorials

[@rdavidmurphy1]

Good query explanation!

[@deepakrawat625]

Sir i do have a question if i choose headers as 1 or -1 i get the same answer so what’s difference between that

[@OCDrBill]

how could you use the QUERY function to return on this data only the top sales reps for each state?

[@solidclouds_starborne]

CTRL SHIFT PgUp/PgDown to switch sheet tabs btw. Great video!

[@ExcelGoogleSheets]

My keyboard doesn't have PgUp/PgDn :) Thanks!

[@EduardoBicelisGarcia]

@@ExcelGoogleSheets I use ALT up arrow to move back tap...

[@rachelperella2747]

How do you do a query like you have shown here that puts data in all columns based on one column criteria (e.g. name)? For example the several people entered the data and you just want to pull all of their data into a new tab.

[@matheusqueiroz5910]

No doubt, the best videos on Google Spreadsheets!!! Thanks for the material! Is there any difference instead of using ORDER BY in the query function, use the SORT( query(...) ,1,true ) ? Thanks!

[@ExcelGoogleSheets]

Not Really, just an extra unnecessary step.

[@josephmuscolino905]

All your videos are incredibly helpful, so thanks for all the work you put into it. However, regarding your examples of utilizing the QUERY function, I'm not sure how this approach is any different than using a Pivot Table. Or, perhaps that's not the point of this video, and you're simply showing people a different approach to filtering data. Either way, I found it insightful, empowering, and quite practical. Just wondering, though: Would there be limitations to accomplishing the same type/degree of filtering by using a Pivot Table instead? Keep up the outstanding work, and thank again!

[@ExcelGoogleSheets]

I don't think it's the same. You can do Pivot Tables using QUERY function, but you can't do QUERY function with Pivot Table. That being said, if you were able to solve your problem with Pivot Table and it works, then you should keep using it.

[@alejandrodevalle]

Hi! thanks for this tutorial!. Inside the function, you're writing the statement in another cell. Is it possible to write the data source in another cell? (In this other cell I'm writing the tab where the query supose to search for data)

[@ExcelGoogleSheets]

Yes. You will need to use INDIRECT function and CONCATENATE.

[@sbfo5060]

Thanks! Can you let me know if it's possible to write the query text that INCLUDES additional external cell references in the 'text' cell as you've demonstrated? I can't seem to get it to work - for example the follow query string returns an error, but works perfectly when pasted directly into the formula. Select * Where Col1=' "&C4&" '. Thanks! Very happy to pay for your advice as I can not find the answer to this ANYWHERE!

[@sbfo5060]

OF COURSE! Having just asked the question I've worked it out. ="Select * Where Col1='"&C4&"'" Thanks again FANTASTIC content.

[@AnandSingh-zq9yj]

Hello I have google sheet with some data in multiple column in my data there are some blank cell. Now I want to use query function for combine all column . When I am trying to use this function this also add blank cells. Please tell me how i can use this for filter blank..

[@electricaldepartment3464]

Hi thanks for your video. How i can use WHERE function to select multiple criteria to display the whole row data. Eg/ T32 or M33 is my primary key. Please assist and thanks

[@alexaespinal5864]

Thank you so much for this! I got the QUERY to work but I would like to know how to remove the data from the original sheet once it's moved to the next sheet.

[@ExcelGoogleSheets]

Copy and paste values only to remove the formula and keep the results, and then go and delete the old data. If you don't like doing this then you'll have to create Apps Script.

[@amolparbat6428]

Thank You for Sharing...had quick question in my data one column has number format as "R1890" when I use query function it returns output as " " ,can you please help me how to resolve this issue.

[@pichit.raetai]

Wow thank you very much

[@direccionnacionaldeeducaci1056]

Hi, how are you, greetings from Panama? I was looking for the second part of your tutorial, since I see that you have other tabs with the names of summary and subtotal. I am carrying a database of participants in seminars and I need to do a query where they can add columns of seminar hours for a same personal identity number. I notice that you make several querys but repeat the marks several times, I would like to know if what I am trying to explain in the paragraph above is possible or if there is a second part of your tutorial. Thank you.

[@senthilkumarc320]

If i make a color to particular cell, i need that color has to change/update on compiled sheet. Please guide

[@j53iliff2]

Cool video

[@VikasMlt]

ONE QUESTION Along with =, >, LIKE, can 'not equal to' also be used?

[@rennongz1039]

How to use query when the data is alphanumeric. I tried using query and importrange but would not recognize alphanumeric character

[@ubfreeh]

How do you LIMIT according to date If I want to return only those that happened after such date and year?

[@essamkhalifa4375]

Excellent Thanks a lot

[@ExcelGoogleSheets]

👍

[@sweetmask1690]

Hi sir can we put formula in sheet title? From cell to sheet title in order to edit easily the names of a plenty sheet at a time

[@hbasumatary1995]

amazing