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.
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 😃
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.
WOWOWOWOWOWOW this is one of the best I've seen in a while !!!
Glad you love it 😃 , i enjoyed making it
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!
Thank You Very Much David Benaim Which is very Great and Useful its amazing
That’s very kind! Thank you!
Good one! Thanks for demonstrating. Thumbs up!!
Glad you enjoyed it!
Thx! Great job!
Glad you like it!
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 😃
Top!🔝
Glad you like it!
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
Great video! very helpful
Glad you enjoyed 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
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 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
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
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