Learn how to get Free YouTube subscribers, views and likes

Get Free YouTube Subscribers, Views and Likes

Use Arrays instead of Ranges to build a query to make your query more error proof

Follow

Google Sheets Tutorials

‪@redtailfanschool‬ In this video we demonstrate the use of the query function using arrays instead of ranges as the data source to prevent errors in the query if the data source changes by moving or adding columns.

posted by sikayiseg1

Use a special QUERY to summarize student data submitted on a form.

Use a special QUERY to summarize student data submitted on a form.

Use the 'SWITCH' formula with a 'QUERY' to make a dynamic dashboard to show Q1,This Year, Last Year

Use the 'SWITCH' formula with a 'QUERY' to make a dynamic dashboard to show Q1,This Year, Last Year

Make Excel Formulas Dynamic with the This Trick

Make Excel Formulas Dynamic with the This Trick

AppsScript to index all files in your google drive owned by you, name, URL,ID,etc,, saved to a sheet

AppsScript to index all files in your google drive owned by you, name, URL,ID,etc,, saved to a sheet

Building A Probabilistic Risk Estimate Using Monte Carlo Simulations

Building A Probabilistic Risk Estimate Using Monte Carlo Simulations

Try This Instead of the XLOOKUP

Try This Instead of the XLOOKUP

NEVER install these programs on your PC... EVER!!!

NEVER install these programs on your PC... EVER!!!

Excel GROUPBY & PIVOTBY Functions All You Need to Know (do they BEAT Pivot Tables? )

Excel GROUPBY & PIVOTBY Functions All You Need to Know (do they BEAT Pivot Tables? )

5 Excel Secrets You'll Be Embarrassed You Didn't Know

5 Excel Secrets You'll Be Embarrassed You Didn't Know

Excel TimeSavers 5 Hidden Features for Busy People

Excel TimeSavers 5 Hidden Features for Busy People

Limit the data source to use a pivot table and a pivot table group to summarize data from a form

Limit the data source to use a pivot table and a pivot table group to summarize data from a form

5 Advanced Excel Formulas You Probably Didn't Know!

5 Advanced Excel Formulas You Probably Didn't Know!

SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)

SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)

Excel Dynamic Search Box Tutorial | Find Anything | MultiColumn Search

Excel Dynamic Search Box Tutorial | Find Anything | MultiColumn Search

Solving Excel COUNT Problems with COUNTIFS Function (practice file included)

Solving Excel COUNT Problems with COUNTIFS Function (practice file included)

The Excel Formula Checklist to Avoid Costly Mistakes (File Included)

The Excel Formula Checklist to Avoid Costly Mistakes (File Included)

Four SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel Part 1

Four SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel Part 1

Excel: INDEX and MATCH

Excel: INDEX and MATCH

Recommended

What Make Up Tutorials Are Like

What Make Up Tutorials Are Like

05:03

Superheros & Their Attempts To Go On Holiday

Superheros & Their Attempts To Go On Holiday

07:41

Can Being Rich Make Your Friends Come Closer?

Can Being Rich Make Your Friends Come Closer?

04:48

Welcome The Most Incredible People 2017!

Welcome The Most Incredible People 2017!

05:06

OxygenOS - The Key To Your Boldest Dreams

OxygenOS - The Key To Your Boldest Dreams

00:49

Moisturizer Boundaries Ruined In Public

Moisturizer Boundaries Ruined In Public

01:32

Terrifying Ghosts, Harpoon Accidents, & Living Puppets | JFL Throwback Pranks

Terrifying Ghosts, Harpoon Accidents, & Living Puppets | JFL Throwback Pranks

08:47