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.
@learnspreadsheets Жыл бұрын
Thanks!!!! Yeah I find this sooo useful 😃
@joyce1551Ай бұрын
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!
@learnspreadsheetsАй бұрын
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.
@joyce1551Ай бұрын
@@learnspreadsheets I'll surely recommend your channel. You are the best, David! You are excelling way and beyond!
@greggswaim10883 жыл бұрын
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.
@SPowers2 жыл бұрын
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.
@learnspreadsheets2 жыл бұрын
That’s a great tip! Thanks Steve 😃
@mosheva2 жыл бұрын
WOWOWOWOWOWOW this is one of the best I've seen in a while !!!
@learnspreadsheets2 жыл бұрын
Glad you love it 😃 , i enjoyed making it
@lafamillecarrington2 жыл бұрын
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.
@learnspreadsheets2 жыл бұрын
Yeah its a lot to get your head around but we’ll worth the effort as it’s so flexible!
@rajendraneupane73992 жыл бұрын
Thank You Very Much David Benaim Which is very Great and Useful its amazing
@learnspreadsheets2 жыл бұрын
That’s very kind! Thank you!
@wayneedmondson10653 жыл бұрын
Good one! Thanks for demonstrating. Thumbs up!!
@learnspreadsheets3 жыл бұрын
Glad you enjoyed it!
@WhatMACHI2 жыл бұрын
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?
@learnspreadsheets2 жыл бұрын
Ooh that’s a good idea with tickboxes for the columns 😃
@mirekkryskapriv7445 Жыл бұрын
Thx! Great job!
@learnspreadsheets Жыл бұрын
Glad you like it!
@Marc1311662 жыл бұрын
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.
@learnspreadsheets2 жыл бұрын
Hey Marc! Glad you like it! Yes email me to david@xlconsulting-asia.com and I can share it
@bryanmoreno81662 жыл бұрын
Is there a reason why my query would give me an error if I have no info entered into my parameters?
@learnspreadsheets2 жыл бұрын
You often need to build in a way to handle blanks for parameters using IF ISBLANK or otherwise
@fortunatodirado3176 Жыл бұрын
Top!🔝
@learnspreadsheets Жыл бұрын
Glad you like it!
@alientrader5582 жыл бұрын
Great video! very helpful
@learnspreadsheets2 жыл бұрын
Glad you enjoyed it!
@farazchughtai2 жыл бұрын
how can i use multiple sort options like dates and variable for each entry
@learnspreadsheets2 жыл бұрын
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
@farazchughtai2 жыл бұрын
@@learnspreadsheets sir thanks, but i will be thankful if you could help me docs.google.com/spreadsheets/d/16kUBYJCmypkB5iQ1jY92vjEVbCnFzvEssfVVXOS64HU/edit#gid=1246380746
@travisrounds61612 жыл бұрын
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?
@learnspreadsheets2 жыл бұрын
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'")
@travisrounds61612 жыл бұрын
@@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)
@learnspreadsheets2 жыл бұрын
@@travisrounds6161 Sure happy to share! Its david@xlconsulting-asia.com
@AnshulMarele-gbaa Жыл бұрын
how to return cell address with XLOOKUP function of a last non-blank cell in google sheets?
@learnspreadsheets Жыл бұрын
Good question but that is beyond what this video can do, it’s a bit tricky
@rafaelafiorindecarvalho3062 жыл бұрын
How can I use weeknum inside query formula?
@learnspreadsheets2 жыл бұрын
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