Home Google Docs Spreadsheet

Spreadsheet

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

Quartile IF in Google Sheets

0
To calculate quartiles based on conditions, referred to as "Quartile IF," we will use a combination of formulas in Google Sheets. Sometimes, you may want...

Drop Rows and Columns by Index Numbers in Google Sheets

0
With the help of two simple custom formulas, we can drop rows and columns by their index number in Google Sheets. One formula is...
Using Field Labels in Query Formula in Google Sheets

Reference a Column by Field Label in Google Sheets QUERY

0
Here we'll explore the two best methods for referencing a column by its field label (header row value) in the Google Sheets QUERY: Named...

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...