When I got into querying in sheets I was excited then thought to myself "I need a query builder..." So I made one myself but mine was focused on creating the formula. Great minds man. Dope video and take on a query builder. Definitely going to use this.
Just to add for anyone reading this, when you get into more advanced query where you are querying data from multiple sources your columns change from A, B and C to Col1, Col2 and Col3. This is such a great tool not only for learning but it ensures you keep your query in there right order since that is required or it won’t work.
You're awesome David! The way you have made this video is just the mind of a genius! This helps me a lot. The video that I understood the most about query builder!!! Please continue to make more videos!
What a lovely comment to read! I'm glad it was helpful, its one of my favourite spreadsheet techniques, I use it regularly! I made a similar video for an Excel version, but the formulas a bit more advanced.
Timing is everything! Today's video may just answer my questions. Thanks for the wonderful way you have developing and conveying examples of spreadsheet functions.
This was great! Going to have a play around with this 👍 I think you’d also be able to put checkboxes next to the column references as a column picker too?
Hello great question but it’s too hard to explain on a thread like this, there are some forums that explain it quite well. This is one example. stackoverflow.com/questions/48550417/multiple-sort-order-by-within-query-in-google-sheets
@@learnspreadsheets sir thanks, but i will be thankful if you could help me docs.google.com/spreadsheets/d/16kUBYJCmypkB5iQ1jY92vjEVbCnFzvEssfVVXOS64HU/edit#gid=1246380746
Would it be possible for you to create a video on this exact topic, but refer to a secondary "Data input" sheet to query from, rather than the data on the same page?
Hi thanks for the question, if you select the range in another sheet it should work just the same, but the sheet name needs to be in the formula, just like referencing any cell/range in another sheet for any formula. Here is an example: =QUERY('Edit speaker deets'!$A$3:$AF$502,"select AC, L, O, N, AB, AD, AE, AF where B='Next event'")
@@learnspreadsheets Much appreciated David! Do you have an email associated with your YT? Since you have assisted me I have a great idea for you! (I promise this isn't spam)
When I got into querying in sheets I was excited then thought to myself "I need a query builder..." So I made one myself but mine was focused on creating the formula. Great minds man. Dope video and take on a query builder. Definitely going to use this.
Thanks!!!! Yeah I find this sooo useful 😃
Just to add for anyone reading this, when you get into more advanced query where you are querying data from multiple sources your columns change from A, B and C to Col1, Col2 and Col3. This is such a great tool not only for learning but it ensures you keep your query in there right order since that is required or it won’t work.
That’s a great tip! Thanks Steve 😃
You're awesome David! The way you have made this video is just the mind of a genius! This helps me a lot. The video that I understood the most about query builder!!! Please continue to make more videos!
What a lovely comment to read! I'm glad it was helpful, its one of my favourite spreadsheet techniques, I use it regularly! I made a similar video for an Excel version, but the formulas a bit more advanced.
@@learnspreadsheets I'll surely recommend your channel. You are the best, David! You are excelling way and beyond!
Timing is everything! Today's video may just answer my questions. Thanks for the wonderful way you have developing and conveying examples of spreadsheet functions.
This was great! Going to have a play around with this 👍 I think you’d also be able to put checkboxes next to the column references as a column picker too?
Ooh that’s a good idea with tickboxes for the columns 😃
Such a helpful video. I think that it will take me a while to get used to building up the query in this way - but definitely worth the effort. Thanks.
Yeah its a lot to get your head around but we’ll worth the effort as it’s so flexible!
WOWOWOWOWOWOW this is one of the best I've seen in a while !!!
Glad you love it 😃 , i enjoyed making it
Thank You Very Much David Benaim Which is very Great and Useful its amazing
That’s very kind! Thank you!
Thx! Great job!
Glad you like it!
Good one! Thanks for demonstrating. Thumbs up!!
Glad you enjoyed it!
Great tool to make query request easier for non query people.
Is there any chance I can find your sheet to download somewhere ?
Thanx again.
Hey Marc! Glad you like it! Yes email me to david@xlconsulting-asia.com and I can share it
how can i use multiple sort options like dates and variable for each entry
Hello great question but it’s too hard to explain on a thread like this, there are some forums that explain it quite well. This is one example. stackoverflow.com/questions/48550417/multiple-sort-order-by-within-query-in-google-sheets
@@learnspreadsheets sir thanks, but i will be thankful if you could help me
docs.google.com/spreadsheets/d/16kUBYJCmypkB5iQ1jY92vjEVbCnFzvEssfVVXOS64HU/edit#gid=1246380746
Is there a reason why my query would give me an error if I have no info entered into my parameters?
You often need to build in a way to handle blanks for parameters using IF ISBLANK or otherwise
Would it be possible for you to create a video on this exact topic, but refer to a secondary "Data input" sheet to query from, rather than the data on the same page?
Hi thanks for the question, if you select the range in another sheet it should work just the same, but the sheet name needs to be in the formula, just like referencing any cell/range in another sheet for any formula. Here is an example: =QUERY('Edit speaker deets'!$A$3:$AF$502,"select AC, L, O, N, AB, AD, AE, AF where B='Next event'")
@@learnspreadsheets Much appreciated David! Do you have an email associated with your YT? Since you have assisted me I have a great idea for you! (I promise this isn't spam)
@@travisrounds6161 Sure happy to share! Its david@xlconsulting-asia.com
Top!🔝
Glad you like it!
Great video! very helpful
Glad you enjoyed it!
how to return cell address with XLOOKUP function of a last non-blank cell in google sheets?
Good question but that is beyond what this video can do, it’s a bit tricky
How can I use weeknum inside query formula?
Hi thanks for the comment. You must add a column which calculates the week number from the date, and then use that in the filter ciriteria
😀
Glad you like it