Google Sheets QUERY Errors: Troubleshooting Guide
Fix common Google Sheets QUERY errors including parse errors, NO_COLUMN, mismatched array row size, mixed data types, headers, Col notation and ARRAY_LITERAL.
Read guideSpreadsheets
Excel and Google Sheets formulas that work.
Google Sheets QUERY: Blank, Null and Empty-String Conditions
Filter blank and non-blank rows in Google Sheets QUERY with is null and is not null, including empty strings, whitespace and formula blanks.
Read guideHow To Ignore Blank And Empty Cells In Google Sheets
Ignore genuinely blank cells, empty strings and whitespace in Google Sheets using FILTER, COUNTIF, LEN, ISBLANK and QUERY.
Read guideJavascript Equivalent of Common Financial Formulas Found In Google Sheets
A practical, example-led guide from Script Everything.
Read guideHighlight Entire Row When Date Column Is In The Same Month And Year As Today
A practical, example-led guide from Script Everything.
Read guideHighlight Row When Two Date Cells In Row Have A Date Between Them: Conditional Formatting Example In Google Sheets
A practical, example-led guide from Script Everything.
Read guideRandomise Range In Google Sheets In 2 Simple Steps (No Plugins Or Script Needed)
A practical, example-led guide from Script Everything.
Read guideNot Null In Google Sheets
Test and filter non-empty Google Sheets cells using ISBLANK, LEN, FILTER, COUNTIF and QUERY is not null, with empty-string caveats.
Read guideHow To Use Google Sheets QUERY SELECT & WHERE With Examples
A practical, example-led guide from Script Everything.
Read guideWhat Are Sheets in Excel? A Clear Explanation for Beginners
A practical, example-led guide from Script Everything.
Read guideHow to Sort Data In Excel: Single Column & Multi-Column
A practical, example-led guide from Script Everything.
Read guideWhat Are Cells in Excel: A Simple Explanation
A practical, example-led guide from Script Everything.
Read guideAbsolute Cells in Excel: Explained With Images
A visual Excel-specific guide to locking cells with $A$1, mixed references and the F4 shortcut when copying formulas.
Read guideDifference Between HLOOKUP And VLOOKUP In Excel
A practical, example-led guide from Script Everything.
Read guideExcel HLOOKUP Examples With Tips And Tricks
A practical, example-led guide from Script Everything.
Read guideWhy Is My VLOOKUP Remaining as a Formula? Troubleshooting
A practical, example-led guide from Script Everything.
Read guideHow to VLOOKUP Across Multiple Sheets in Excel: Examples Included
A practical, example-led guide from Script Everything.
Read guideExcel SUMIF: How to Sum Cells Starting with a Letter
A practical, example-led guide from Script Everything.
Read guideSum Only Positive Numbers in Excel: SUMIF & SUMIFS Examples
A practical, example-led guide from Script Everything.
Read guideExcel SUM Function Not Adding Correctly: Troubleshooting Tips
A practical, example-led guide from Script Everything.
Read guideHow to Change an Excel Formula: A Simple Guide for Beginners
A practical, example-led guide from Script Everything.
Read guideCalculate Duration In Years And Months: Excel
A practical, example-led guide from Script Everything.
Read guideHow To Build A Formula in Excel
A practical, example-led guide from Script Everything.
Read guideIF Formulas in Excel: A Beginner's Guide
A practical, example-led guide from Script Everything.
Read guideMost Used Excel Formulas: Boost Your Productivity With These Essential Functions
A practical, example-led guide from Script Everything.
Read guideHow to Find Data in Excel: A Step-by-Step Guide
A practical, example-led guide from Script Everything.
Read guideMicrosoft Excel Quit Unexpectedly: Troubleshooting Tips and Solutions
A practical, example-led guide from Script Everything.
Read guideHow to Improve at Excel: Tips and Tricks for Mastering Spreadsheets
A practical, example-led guide from Script Everything.
Read guideWhen To Use $ In Excel: A Quick Guide
A practical, example-led guide from Script Everything.
Read guideWhy Does Excel Use # Characters in Cells?
A practical, example-led guide from Script Everything.
Read guideWhy Learn Excel?
A practical, example-led guide from Script Everything.
Read guideGoogle Sheets Named Functions In 5 Minutes
A practical, example-led guide from Script Everything.
Read guideGoogle Sheets SWITCH Formula Example: Refactor IF Functions By 20%
A practical, example-led guide from Script Everything.
Read guideHow To Set A Default Value For VLOOKUP
A practical, example-led guide from Script Everything.
Read guide3 Different Ways To Underline In Google Sheets: Shortcuts, Borders & Formulas
A practical, example-led guide from Script Everything.
Read guideCreate Unique ID With Dates: Google Sheets
A practical, example-led guide from Script Everything.
Read guide5 Easy Ways To Fix Google Sheets When It Is Slow
A practical, example-led guide from Script Everything.
Read guide3 Ways To Wrap Text In Google Sheets
A practical, example-led guide from Script Everything.
Read guide5 Ways To Alphabetize In Google Sheets (Screenshots)
A practical, example-led guide from Script Everything.
Read guide3 Ways To Use Multiple Criteria In Google Sheets QUERY Function (Examples)
A practical, example-led guide from Script Everything.
Read guideGoogle Sheets: 3 Ways To Reference Data In Another Sheet (Examples)
A practical, example-led guide from Script Everything.
Read guideGoogle Sheets HLOOKUP Function With Examples
A practical, example-led guide from Script Everything.
Read guideHow To Change Aggregate Name In Google Sheet QUERY Function (Examples)
A practical, example-led guide from Script Everything.
Read guideHow To Aggregate Data From Multiple Sheets With QUERY In Google Sheets
A practical, example-led guide from Script Everything.
Read guideConcatenate Multiple Ranges Into One And Filter Using QUERY: Google Sheets (Example)
A practical, example-led guide from Script Everything.
Read guideGoogle Sheets QUERY Function WHERE Reference To Cell Value: Examples
A practical, example-led guide from Script Everything.
Read guideConditional Formatting With Checkboxes In Google Sheets
A practical, example-led guide from Script Everything.
Read guideHow To Highlight Duplicates In A Range: Google Sheets Conditional Formatting
A practical, example-led guide from Script Everything.
Read guideREGEXEXTRACT Date From String In Google Sheets
A practical, example-led guide from Script Everything.
Read guideApply Conditional Formatting To Entire Row: Google Sheets
A practical, example-led guide from Script Everything.
Read guideWhat Does $A$1 Mean in Excel or Google Sheets?
In Excel and Google Sheets, $A$1 is an absolute cell reference: both column A and row 1 remain fixed when a formula is copied.
Read guideWhat Does $A$1 Mean? Absolute References in Excel and Google Sheets
Understand what $A$1, $A1 and A$1 mean and how absolute and mixed references behave when formulas are copied in Excel and Google Sheets.
Read guideHow To Delete App Script File And Project From Google Sheets
A practical, example-led guide from Script Everything.
Read guideConditional Formatting With Custom Formula Using Relative References
A practical, example-led guide from Script Everything.
Read guideGoogle Sheets Multi Select Dropdown List
A practical, example-led guide from Script Everything.
Read guideHow To Make An Email Address Clickable In Excel
A practical, example-led guide from Script Everything.
Read guideSet Conditional Format Based On Another Cell Value In Google Sheets
A practical, example-led guide from Script Everything.
Read guideWe're sorry, a server error occurred while reading from storage. Error code NOT_FOUND
A practical, example-led guide from Script Everything.
Read guideHow To Clean And Format Phone Numbers In Google Sheets
A practical, example-led guide from Script Everything.
Read guide5 Alternatives To VLOOKUP Function: How To Get Values To The Left Of VLOOKUP Range
A practical, example-led guide from Script Everything.
Read guideHow To Format Text Like 1st Jan 22 To A Date In Google Sheets
A practical, example-led guide from Script Everything.
Read guideHow To Sort By Date In Google Sheets And What To Do When It Doesn't Work
A practical, example-led guide from Script Everything.
Read guideHow To Use The SWITCH Function In Google Sheets?
A practical, example-led guide from Script Everything.
Read guideAdd Formula In Excel: Examples
A practical, example-led guide from Script Everything.
Read guideHow To Separate Characters Into Cells In Excel
A practical, example-led guide from Script Everything.
Read guideHow Do You Type A + (Plus) In Excel?
A practical, example-led guide from Script Everything.
Read guideHow To Get Rid Of E+(Number) In Excel
A practical, example-led guide from Script Everything.
Read guideWhy Does VLOOKUP Return #N/A When Value Exists? (Examples)
A practical, example-led guide from Script Everything.
Read guideHow To Use Noncontiguous Ranges In QUERY Function: Google Sheets
A practical, example-led guide from Script Everything.
Read guideHow To Unmerge Multiple Cells With One Click: Google Sheets
A practical, example-led guide from Script Everything.
Read guideHow Do You Put Multiple Conditions In One Cell In Google Sheets?
A practical, example-led guide from Script Everything.
Read guideReverse Last Name, First Name With Comma Using One Formula: Google Sheets
A practical, example-led guide from Script Everything.
Read guideGoogle Sheets: IF Statement Multiple Conditions
A practical, example-led guide from Script Everything.
Read guideHow To Check If Cell Is Empty (Or Not): Google Sheets
A practical, example-led guide from Script Everything.
Read guideWhat Is The Formula To Calculate Age?
A practical, example-led guide from Script Everything.
Read guideGoogle Sheets Count If Not Blank: Best Approach
A practical, example-led guide from Script Everything.
Read guideHow To Lock A Column In Google Sheets
A practical, example-led guide from Script Everything.
Read guideHow To Make A Header Row In Google Sheets
A practical, example-led guide from Script Everything.
Read guideIgnore Blank Cells In IF Functions Google Sheets
A practical, example-led guide from Script Everything.
Read guideHow To Format Numbers In Thousands (K) In Google Sheets
Show Google Sheets numbers in thousands (k) or millions (m) with a custom number format code, including rounding, decimals and negative values.
Read guideCalculate Days Between Two Dates In Google Sheets: DATEDIF Formula
A practical, example-led guide from Script Everything.
Read guideFlip ARRAY_CONSTRAIN Formula in Google Sheets (Example)
A practical, example-led guide from Script Everything.
Read guideIgnore Blank Cells in QUERY Function Google Sheets
A practical, example-led guide from Script Everything.
Read guideMerge Two Columns Using QUERY: Google Sheets (Step By Step Example)
A practical, example-led guide from Script Everything.
Read guideGoogle Sheets QUERY: Merge Multiple Columns - Expand Into New Structure (Example)
A practical, example-led guide from Script Everything.
Read guideHow To Sum A Dynamic Range: Google Sheets (Example)
A practical, example-led guide from Script Everything.
Read guideHow To Fix Invalid Property Assignment (Error 450)
A practical, example-led guide from Script Everything.
Read guideGoogle Apps Script: Set Value Of Blank Cell
A practical, example-led guide from Script Everything.
Read guideHow To Merge Two Columns Into One (Google Sheets)
A practical, example-led guide from Script Everything.
Read guide3 Ways To Make VLOOKUP Dynamic In Google Sheets (Examples)
A practical, example-led guide from Script Everything.
Read guide