Home Google Docs Spreadsheet

Spreadsheet

Best Google Spreadsheet (Sheets) formula examples: Query, Match, Lookup, Lambda, Database Functions, etc.

XLOOKUP and Offset Results in Google Sheets

0
In Google Sheets, when you want to use XLOOKUP to find a value in a column and retrieve a value from the row above...

Sum Last Value in a Column Across Multiple Sheets in Google Sheets

0
We can use a dynamic formula to sum the last value in a column across multiple sheets within a file in Google Sheets. The...

Winning/Losing/Tie Streaks in a Filtered Range in Google Sheets

0
In a filtered table range, how do you determine the current or longest winning/losing/tie streaks in Google Sheets? For example, you have three columns in...

Finding Current Win/Loss Streak in Google Sheets

0
Understanding the current winning or losing streak is important when managing sports or gaming data in Google Sheets. In a previous guide, we talked...

Remove or Replace Last Character from a String in Google Sheets

0
To remove or replace the last character from a string in Google Sheets, you can utilize either a formula or the Find and Replace...

Google Sheets: Filter Rows with Furthest Data in Each Category

0
This tutorial explores advanced filtering techniques in Google Sheets, specifically focusing on filtering rows with the furthest data within each category. We will apply the...