Google Sheets: QUERY how to Select and FILTER spreadsheet data by Specific Condition

2,079 views

Welington Planilhas

Published on Oct 3, 2024
About :

In this video, you'll learn how to use the powerful QUERY function in Google Sheets to work dynamically with your data. I'll show you how to use the main parameters of the QUERY function — data, query, and header — and teach you commands like SELECT *, WHERE, AND, OR, and ORDER BY to filter, organize, and sort your data in ascending and descending order. In addition, we'll explore how the header parameter can be used to select the number of rows that contain the titles of your table. If you want to have more freedom and control over your queries in Google Sheets, this tutorial is for you! Topics covered: ✅ How to use the QUERY function in Google Sheets. ✅ Filtering data with the SELECT, WHERE, AND, OR commands. ✅ Sorting data with ORDER BY (ascending and descending). ✅ Using the header parameter to define the number of rows of the title. Hope it helps! If this content was useful in any way, how about sharing it with your friends and family, who knows, it might help them too. If you are new to the channel or are not yet subscribed, I invite you to subscribe so you don't miss the next videos in this series. 🔔 To subscribe to my channel, click on the link below: / @welington.planilhas A big hug and I'll see you in the next video. ✍️ If you have any questions or suggestions for how I can improve the content I share here on the channel, write to me in the comments so I can find out and answer you. ⏯ See also: 👉 Google Sheets: QUERY how to do SUM and AVERAGE calculations in the QUERY function in Google Sheets. • Google Sheets: QUERY how to do Calc... 👉 Google Sheets: All About - How to create your first PIVOT TABLE in Google Sheets • Google Sheets: All About - How to crea... 👉 Google Sheets: How to EXTRACT only PART of the TEXT by combining 2 functions in Google Sheets - SMD #2 • Google Sheets: How to EXTRACT only PART... 👉 Google Sheets: How to use the SUM and AVERAGE functions in Google Sheets • Google Sheets: How to use the... 👉 Google Sheets: How to CREATE a beautiful and stress-free COLUMN CHART in Google Sheets. • Google Sheets: How to CREATE a GRAPH... 📝 About my channel @welington.planilhas Here you will find TIPS, TUTORIALS and PRACTICAL SOLUTIONS for everyday life that will make your work using Google spreadsheets FASTER and MORE EFFICIENT, saving you TIME and increasing your PRODUCTIVITY. To not miss the next videos, I invite you to subscribe to my channel by clicking on the link below: / @welington.planilhas #WelingtonPlanilhas #query #GooglePlanilhas #GoogleSheets #GooglePlanilhas #GooglePlanilhas #PlanilhasDoGoogle #Planilhas

  • vidoe Comments
Trend Videos
26:46
[VLOG] 6 years after marriage, father visits daughter's house for the first time👴🏻❗️(Proud Yujun, starts dieting)
리쥬라이크 LIJULIKE
733,120 views   2 days ago
12:52
145,000 won per person? The most expensive strawberry buffet in Korea
더들리
493,147 views   1 day ago
2:15
[Captain America: Brave New World] Main Trailer
MarvelKorea
678,893 views   1 day ago
12:10
I waited 7 hours to buy strawberry soup for my wife who had just given birth.
네루짱NERU
520,149 views   2 days ago
23:52
Noh Hong-chul surprised by the current Bali price level (self-cooking, close friend travel)
노홍철
314,448 views   1 day ago
9:55
I will tell you honestly why I did not receive the diamond button related to the number of subscribers.
보겸TV
1,281,307 views   2 days ago
4:09
BOYNEXTDOOR (보이네스트도어) 'Today Only I LOVE YOU' Official MV
HYBE LABELS
6,826,028 views   1 day ago
23:38
SNL vs XXXL! A talk show where two real crazy people make each other crazy Takdae EP24 Kim Ah-young
빠더너스 BDNS
972,484 views   2 days ago
0:19
RIIZE RISE 'Hug' Stage Video Teaser
SMTOWN
164,114 views   1 day ago
9:59
🥔Ep. 0 ㅣ CEO KWANGSOO Dreams Big, KYUNG SOO Makes It Happenㅣ👨‍🍳🥔GBRB Spinoff
채널십오야
877,750 views   1 day ago
48:25
'Squid Game 2' Review
침착맨
949,291 views   2 days ago
21:15
A heart-pounding winter survival operation💕
원지의하루
347,529 views   1 day ago
29:22
2025 LCK CUP Draft
LCK
374,599 views   1 day ago
11:41
NIS Security Level(?), The Truth I Learned After My Husband Disappeared Y Drive
궁금한 Y
543,988 views   3 days ago
23:38
SNL vs XXXL! A talk show where two real crazy people make each other crazy Takdae EP24 Kim Ah-young
빠더너스 BDNS
972,484 views   2 days ago
39:38
[Ep.21] Kim Won-hee calls Kim Yong-man OO? ㅣ The truth about the KakaoTalk message from 3 years ago that embarrassed Kim Yong-man [Jo Dong-ari Episode 21]
조동아리
381,341 views   2 days ago
7:45
[39th Golden Disk] GFRIEND - 'Intro + Running Through Time + Night + In Our Affectionate Season' ♪ JTBC 250107 Broadcast
Golden Disc
964,097 views   1 day ago
5:15
Blue and Summer - Mrs. GREEN APPLE / COVER by LILPA
릴파 lilpa
1,011,153 views   11 days ago
43:38
Everyone was moved to tears by the actions of the scrapyard grandmother. Seol-sam stepped forward for the 9 companion dogs that became the light of an 81-year-old grandmother who lost her entire family and lives alone. #Whyareyousocute
EBS 세나개 x 고부해 - 왜그러냥? 귀엽개!
353,093 views   4 days ago
12:47
An American grandpa who came to Cherry's Taekwondo observation class and was surprised lol
올리버쌤
559,900 views   4 days ago
12:20
dream
유우키의 일본이야기 YUUKI
342,770 views   3 days ago
11:45
If you want to buy a laptop, now is the time. Why is there chaos in the community right now?
ITSub잇섭
1,202,441 views   3 days ago
21:13
2025 Season 1 [Invitation to Noxus] Season Opening Draft 2025 LCK
LCK
493,344 views   2 days ago
9:22
No, honey, stop crying;;
김계정
455,319 views   3 days ago
13:32
To be or not to be thyroid cancer, that is the question...
배말랭
459,796 views   2 days ago
11:45
If you want to buy a laptop, now is the time. Why is there chaos in the community right now?
ITSub잇섭
1,202,441 views   3 days ago
10:24
A man you absolutely must not miss
짧은대본 ShortPaper
1,677,384 views   10 days ago
25:50
[Eating Vlog #109] I finally tried rose-duruchigi. But the taste..🤔 I'm the one who eats mackerel 3 times a week🐟 Hippo pound bagel, heart tiramisu, spicy noodles, cheese stir-fried noodles + pudding hotdog + cheese ball
살빼조DietJo
462,458 views   5 days ago
1:33:36
An exciting night in Sa Pa & endless talks Punghyanggo EP.4 Vietnam Sa Pa
뜬뜬 DdeunDdeun
5,586,295 views   2 weeks ago
10:56
Camping scale of the other world... Now we are even building a camping village
김숙티비kimsookTV
270,809 views   1 day ago
15:07
Lee Ji-hye's emotional surprise camera of her husband who bursts into tears (Terry Ellie, crying)
밉지않은 관종언니
256,999 views   1 day ago
7:45
[39th Golden Disk] GFRIEND - 'Intro + Running Through Time + Night + In Our Affectionate Season' ♪ JTBC 250107 Broadcast
Golden Disc
964,097 views   1 day ago
Google AdSense
336 x 280
Up Next
13:36
New iM5+ full color outdoor wi-fi camera how to configure application: Mibo Cam
Marcos Matos e você o rei das câmeras
13,328 views
2 years ago
3:11:01
COMPLETE COURSE FROM ZERO TO 50 THOUSAND IN THE FREE MARKET IN 2024
Walace Messias - Shark ecommerce
216,850 views
8 months ago
18:26
Intelbras iM5 S Full HD outdoor Wi-Fi camera how to configure
Marcos Matos e você o rei das câmeras
23,650 views
3 years ago
13:40
INSTALLING AND CONFIGURING INTELBRAS WIFI EXTERNAL CAMERA WITH AUDIO (IM5 S)
OJI SECURITY
195,301 views
3 years ago
8:07
How to configure the Intelbras iM5-SC external Wi-Fi camera compatible with Alexa and Google.
Aplicando Engenharia
39,484 views
1 year ago
11:25
Intelbras iM5-SC external Wi-Fi camera how to record via memory card app: Mibo Cam
Marcos Matos e você o rei das câmeras
11,858 views
2 years ago
8:07
Intelbras IMX C Mibo camera how to easily configure application: MiboCam
Marcos Matos e você o rei das câmeras
39,392 views
1 year ago
11:03
How to configure Intelbras IM3 camera and its MANY FUNCTIONS
Conexão CFTV
369,985 views
4 years ago
15:01
iM7 Full Color 360⁰ Outdoor Wi-Fi Camera How to Set Up App: MIBO CAM
Marcos Matos e você o rei das câmeras
78,017 views
2 years ago
10:07
Functions and Settings of Your Intelbras Security Camera: A Complete Guide via the APP
O Knaipp
17,572 views
1 year ago
7:41
HOW TO RESET THE INTELBRAS IM5 FULL COLOR CAMERA TO FACTORY SETTINGS
Rodrigo Ferrari
1,030 views
2 months ago
12:41
HOW TO CONFIGURE MOTION DETECTION ON MIBO IM5 TECHSERVICEONE WELTON 💡⚙️
TECHSERVICEONE - WELTON BRUNO LINO
30,851 views
4 years ago
9:07
How to configure the Intelbras iM5+ external Wi-Fi camera compatible with Alexa and Google.
Aplicando Engenharia
12,889 views
1 year ago
24:52
MIBO IC4 INTELBRAS CAMERA Learn how to set up!
Papo Segurança com Alexandre Rodrigues
223,000 views
5 years ago
11:53
Review of the Mibo iM5s outdoor smart camera Intelbras
LAB4 - Inspirando os entusiastas da tecnologia
27,357 views
3 years ago
6:39
Intelbras iMX Mibo Camera Presentation and How to Install
Upperseg Superioridade Em Segurança
78,887 views
3 years ago
19:46
presentation INTELBRAS WI-FI CAMERAS!!! which one to buy?
CAIQUE DAS CAMERAS
65,857 views
1 year ago
45:44
HOW TO INSTALL WIFI CAMERA ON NVR
LetraJota
236,396 views
5 months ago
4:32
Access im5 S camera via cable
Andre Carmelito
9,915 views
2 years ago
18:08
How to configure the Intelbras iM3 black Full HD Wi-Fi camera
Marcos Matos e você o rei das câmeras
22,018 views
3 years ago
12:47
[Guaranteed to sleep outdoors] At 1am, the sea is right in front of me... I rode the scariest last train on the Tokaido Line! I took the last train to the last stop #20
ナオヤ鉄道ch
377,625 views
7 months ago
17:23
[Sleeping rough guaranteed] Crossing 1 metropolis and 2 prefectures! I rode the terrifying last train to the very end of Kanagawa! I took the last train to the end of the line #27
ナオヤ鉄道ch
593,441 views
6 months ago
11:28
[A rare trip past 1am] I rode the last train on the Odakyu Line I rode the last train to the last stop #60
ナオヤ鉄道ch
102,368 views
1 month ago
13:35
[Passing 29 stations] I rode the fastest rapid express train on the Odakyu Line, which is as fast as a limited express! #OdakyuLine #Odakyu #OdakyuElectricRailway #OdakyuOdawaraLine #RapidExpress #Odakyu5000Series #FastestTrain
山手快速
24,245 views
3 months ago
14:28
[Guaranteed to sleep outside] I tried riding the last train to the end of the line, which was so scary that I ran out of energy just before reaching downtown Tokyo I tried riding the last train to the end of the line #44
ナオヤ鉄道ch
177,719 views
3 months ago
20:39
[Guaranteed to sleep outside] I rode the last train to the end of the metropolitan area! I rode the last train to the end of the line #34
ナオヤ鉄道ch
437,381 views
5 months ago
13:07
[Sleeping outdoors guaranteed] I rode the last train to the end of Kanto and the highest point in Kanagawa I rode the last train to the end of the line #52
ナオヤ鉄道ch
135,021 views
2 months ago
21:33
[Don't fall asleep] I missed the most terrifying last train in Japan I went to the last stop on the last train #48
ナオヤ鉄道ch
159,929 views
2 months ago
15:39
[I'll definitely be sleeping outside] I ended up exhausted at the station, so I tried to ride the last train to the end of the line I tried to ride the last train to the end of the line #47
ナオヤ鉄道ch
208,984 views
3 months ago
11:52
[Don't oversleep] I woke up in the mountains!? I rode the last train on the Chuo Line, the scariest one yet! I took the last train to the last stop #7
ナオヤ鉄道ch
740,504 views
1 year ago
12:32
[Sleeping outdoors guaranteed] I rode the latest last train in the Tohoku region! I rode the last train to the last stop #33
ナオヤ鉄道ch
220,796 views
5 months ago
12:36
[Timetable change] What's next for Odakyu Line express trains?
てつたん
8,472 views
2 weeks ago
58:26
[#3 Driving Part 2] Sotetsu/Tokyu Shin-Yokohama Line Plarail Driving Event Report Video
every dayday
56,166 views
1 month ago
14:06
[Guaranteed to be sleeping rough] I took the terrifying last train from the big city, which takes you to despair in just 25 minutes! I took the last train to the last stop #36
ナオヤ鉄道ch
292,545 views
5 months ago
Google AdSense
336 x 280

fetery.com. Copyright 2024