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

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!

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

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!

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

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

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

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

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

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

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

Looking forward to part 2. Thank you.

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

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

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.

THANK YOUUUUUUUUUUUU THIS IS EXACTLY WHAT I WAS LOOKING FOR

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

Awesome tutorial. Helped me understand Queries, thank you!

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

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

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

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

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

One of the best channel for learning google sheet.

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

Powerful tools! Thank you so much, bro.

Another great video! Thank you

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

Thank you, it make my work a lot easier

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

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

Always a great teacher!!

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

these explanations are very clear, thank you very much

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

very clear and concise, thankyou

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🤗

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

Extremely Excellent !

Thank You +Learn Google Spreadsheets for this series!

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

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

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

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

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

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

Great video, thank you!

Thank you. 19:29 I relly need this

Really good video

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

Thank you so much!

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!

GREAT DESCRIPTIONS!

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.

Thanks. Learn a lot.

Thank you so much for the lesson

Excellente! Tks

finally gets started one minute into video

very helpful thanks for the tuts

Helps alot, thanx

very helpful tutorials

so clear so net . thank you for this post

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

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?

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

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!

Thank you so much great video!

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!

Excellent!

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)

Thank you soooooo much, life saver :)

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

You are the best!!!

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

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 :)

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

Thanks man!

Good query explanation!

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!!

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?

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

Cool video

Wow thank you very much

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

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

Thank you so much for this! I am getting super organized :) Can this be done getting data from multiple sheets?

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)

Maybe an idea for some future video: So I have made a query formula like this ={QUERY('OLD application form Responses'!A1:M;"SELECT A,D,E,F,J WHERE B='Yes'";1);QUERY('Responses 1/2'!A1:T;"SELECT A,E,F,G,K WHERE B='Yes'";0)} In order for my colleagues not to mess it up, I have protected cell with that formula with a password. But now there is a problem they can not filter the results. So I think a good solution would be for my formula to display results one row beneath so the cell protection would not affect their ability to filter. Any idea on how to solve this puzzle?

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.

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.

I AM ON MY KNEES RIGHT NOW, YOU JUST SAVED A MAC BOOK PRO FROM GETTING CURB STOMPED.

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

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.

amazing

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..

Excellent Thanks a lot

Hi, Your entire series is interesting. Kindly help me in resolving this attendance sheet which i gather with google forms from my employees,. where i get data in one single column. How do i separate this DATE wise in one single sheet , with the time horizontally like Dates 1, 2, 3, .... ? 11/2/2018 9:20:45 David 11/2/2018 9:35:45 John 11/2/2018 9:56:45 Lara 11/3/2018 9:27:10 David 11/3/2018 9:30:10 Jhon 11/3/2018 9:45:10 Lara 11/4/2018 9:29:10 Jhon 11/4/2018 9:46:10 David 11/4/2018 9:50:10 Lara

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.

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

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

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