Google Docs Archives

Using Table and Column Names Instead of Explicit Cell References

Structured Table References in Formulas in Google Sheets

Prashanth KV - May 13, 2024 0

Highlight Data Spikes (Consecutive Increases) in Google Sheets

Prashanth KV - February 25, 2024 0

XLOOKUP in Merged Cells in Google Sheets

Prashanth KV - March 31, 2024 0

XLOOKUP for Multiple Column Results in Google Sheets

Prashanth KV - February 4, 2024 1

Customizing Alternating Colors of a Table in Google Sheets

Prashanth KV - May 13, 2024 0

Filter Rows Based on Criteria List with Wildcards in Google Sheets

Prashanth KV - February 28, 2024 0

Conditional Formatting for Pivot Tables in Google Sheets

Prashanth KV - April 7, 2024 0

XLOOKUP with Date and Time in Google Sheets

Prashanth KV - February 7, 2024 0

UNIQUE Function in Visible Rows in Google Sheets

Prashanth KV - May 13, 2024 0

Google Sheets: Filter Rows with Furthest Data in Each Category

Prashanth KV - March 1, 2024 0

1...134135136 137 Page 135 of 137

Get the First or Last Row/Column in a New Google Sheets…

UNIQUE Function in Visible Rows in Google Sheets

Customizing Alternating Colors of a Table in Google Sheets

Structured Table References in Formulas in Google Sheets

Converting a Range to a Table and Vice Versa in Google…

Automatically Pre-fill Google Forms from Google Sheets: A Step-by-Step Guide

How to Set Up Google Docs Forms: A Comprehensive Guide

How to Insert Drop-downs in Google Docs Documents

How to Create a Table and Pin and Unpin Header Rows…

How to Use Section Break in Google Docs

How to Split a Table in Google Docs

How to Create First Line Indent and Hanging Indent in Google…

Excel: Month Name to Number & Number to Name

EXPAND + Stacking: Expand an Array in Excel

Creating Custom Descending Sequence Lists in Excel

Running Total By Month in Excel

Get Top N Values Using Excel’s FILTER Function

SUMIFS with XLOOKUP in Excel and Google Sheets

Counting XLOOKUP Results with COUNTIFS in Excel and Google Sheets

SORT and SORTBY – Excel Vs Google Sheets

SUMPRODUCT Differences: Excel vs. Google Sheets

BYCOL Differences: Sheets vs. Excel

Google Docs

Structured Table References in Formulas in Google Sheets

Highlight Data Spikes (Consecutive Increases) in Google Sheets

XLOOKUP in Merged Cells in Google Sheets

XLOOKUP for Multiple Column Results in Google Sheets

Customizing Alternating Colors of a Table in Google Sheets

Filter Rows Based on Criteria List with Wildcards in Google Sheets

Conditional Formatting for Pivot Tables in Google Sheets

XLOOKUP with Date and Time in Google Sheets

UNIQUE Function in Visible Rows in Google Sheets

Google Sheets: Filter Rows with Furthest Data in Each Category