QUERY builder in Google Sheets

  Рет қаралды 13,642

David Benaim

David Benaim

Күн бұрын

Пікірлер
@antcannon
@antcannon Жыл бұрын
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
@learnspreadsheets Жыл бұрын
Thanks!!!! Yeah I find this sooo useful 😃
@joyce1551
@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
@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
@joyce1551 Ай бұрын
@@learnspreadsheets I'll surely recommend your channel. You are the best, David! You are excelling way and beyond!
@greggswaim1088
@greggswaim1088 3 жыл бұрын
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.
@SPowers
@SPowers 2 жыл бұрын
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.
@learnspreadsheets
@learnspreadsheets 2 жыл бұрын
That’s a great tip! Thanks Steve 😃
@mosheva
@mosheva 2 жыл бұрын
WOWOWOWOWOWOW this is one of the best I've seen in a while !!!
@learnspreadsheets
@learnspreadsheets 2 жыл бұрын
Glad you love it 😃 , i enjoyed making it
@lafamillecarrington
@lafamillecarrington 2 жыл бұрын
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.
@learnspreadsheets
@learnspreadsheets 2 жыл бұрын
Yeah its a lot to get your head around but we’ll worth the effort as it’s so flexible!
@rajendraneupane7399
@rajendraneupane7399 2 жыл бұрын
Thank You Very Much David Benaim Which is very Great and Useful its amazing
@learnspreadsheets
@learnspreadsheets 2 жыл бұрын
That’s very kind! Thank you!
@wayneedmondson1065
@wayneedmondson1065 3 жыл бұрын
Good one! Thanks for demonstrating. Thumbs up!!
@learnspreadsheets
@learnspreadsheets 3 жыл бұрын
Glad you enjoyed it!
@WhatMACHI
@WhatMACHI 2 жыл бұрын
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?
@learnspreadsheets
@learnspreadsheets 2 жыл бұрын
Ooh that’s a good idea with tickboxes for the columns 😃
@mirekkryskapriv7445
@mirekkryskapriv7445 Жыл бұрын
Thx! Great job!
@learnspreadsheets
@learnspreadsheets Жыл бұрын
Glad you like it!
@Marc131166
@Marc131166 2 жыл бұрын
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.
@learnspreadsheets
@learnspreadsheets 2 жыл бұрын
Hey Marc! Glad you like it! Yes email me to david@xlconsulting-asia.com and I can share it
@bryanmoreno8166
@bryanmoreno8166 2 жыл бұрын
Is there a reason why my query would give me an error if I have no info entered into my parameters?
@learnspreadsheets
@learnspreadsheets 2 жыл бұрын
You often need to build in a way to handle blanks for parameters using IF ISBLANK or otherwise
@fortunatodirado3176
@fortunatodirado3176 Жыл бұрын
Top!🔝
@learnspreadsheets
@learnspreadsheets Жыл бұрын
Glad you like it!
@alientrader558
@alientrader558 2 жыл бұрын
Great video! very helpful
@learnspreadsheets
@learnspreadsheets 2 жыл бұрын
Glad you enjoyed it!
@farazchughtai
@farazchughtai 2 жыл бұрын
how can i use multiple sort options like dates and variable for each entry
@learnspreadsheets
@learnspreadsheets 2 жыл бұрын
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
@farazchughtai
@farazchughtai 2 жыл бұрын
@@learnspreadsheets sir thanks, but i will be thankful if you could help me docs.google.com/spreadsheets/d/16kUBYJCmypkB5iQ1jY92vjEVbCnFzvEssfVVXOS64HU/edit#gid=1246380746
@travisrounds6161
@travisrounds6161 2 жыл бұрын
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?
@learnspreadsheets
@learnspreadsheets 2 жыл бұрын
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'")
@travisrounds6161
@travisrounds6161 2 жыл бұрын
@@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)
@learnspreadsheets
@learnspreadsheets 2 жыл бұрын
@@travisrounds6161 Sure happy to share! Its david@xlconsulting-asia.com
@AnshulMarele-gbaa
@AnshulMarele-gbaa Жыл бұрын
how to return cell address with XLOOKUP function of a last non-blank cell in google sheets?
@learnspreadsheets
@learnspreadsheets Жыл бұрын
Good question but that is beyond what this video can do, it’s a bit tricky
@rafaelafiorindecarvalho306
@rafaelafiorindecarvalho306 2 жыл бұрын
How can I use weeknum inside query formula?
@learnspreadsheets
@learnspreadsheets 2 жыл бұрын
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
@ikhwansaputera80
@ikhwansaputera80 2 жыл бұрын
😀
@learnspreadsheets
@learnspreadsheets 2 жыл бұрын
Glad you like it
QUERY Complete guide: Google Sheets' most complex function
18:06
David Benaim
Рет қаралды 47 М.
Better tables in Google Sheets with 20 rarely used tips
16:47
David Benaim
Рет қаралды 17 М.
My scorpion was taken away from me 😢
00:55
TyphoonFast 5
Рет қаралды 2,7 МЛН
Гениальное изобретение из обычного стаканчика!
00:31
Лютая физика | Олимпиадная физика
Рет қаралды 4,8 МЛН
“Don’t stop the chances.”
00:44
ISSEI / いっせい
Рет қаралды 62 МЛН
黑天使只对C罗有感觉#short #angel #clown
00:39
Super Beauty team
Рет қаралды 36 МЛН
Google Sheets: Dynamic Arrays - SORTN, SPLIT, QUERY, SPARKLINE++
14:40
Google Sheets Import Range | Multiple Sheets | Import Data | With Query Function
10:36
QUERY Function - Select Columns with Checkboxes - Google Sheets
15:41
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 39 М.
Google Sheets - Join Tables using VLOOKUP & QUERY Functions
16:53
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 49 М.
Google Sheets Query Function Explained
12:35
Leila Gharani
Рет қаралды 330 М.
The Excel Functions Almost Everyone Overlooks (Better Than SUMIFS)
10:29
MyOnlineTrainingHub
Рет қаралды 132 М.
Google Sheets Query Function: A Complete Guide
15:11
Coefficient
Рет қаралды 12 М.
QUERY Function in Google Sheets - 2024 Tutorial ✏️
14:33
Coupler․io Academy
Рет қаралды 38 М.
Google Sheets BEATS Excel with THESE 10 Features!
16:31
Leila Gharani
Рет қаралды 521 М.
My scorpion was taken away from me 😢
00:55
TyphoonFast 5
Рет қаралды 2,7 МЛН