Google Sheets
How to Select Every Nth Row in Google Sheets
You can use the following formula to select every nth row in Google Sheets:
=OFFSET($A$1,(ROW()-1)*n,0)
This formula selects every nth row.
Simply change the value for n...
Google Sheets
Google Sheets: Formula for “If Time is Greater Than”
You can use the following formula to create an IF statement that compares the time in a cell to some specific time in Google...
Google Sheets
Google Sheets: Create Pivot Table with Unique Counts
The following step-by-step example shows how to create a pivot table in Google Sheets that displays the count of unique values of some variable.
Step...
Google Sheets
Google Sheets: Create Pivot Table with Count of Occurrences
The following step-by-step example shows how to create a pivot table in Google Sheets that displays the count of occurrences of values.
Step 1: Enter...
Google Sheets
Google Sheets: Add Strikethrough When Checkbox is Checked
You can use the custom formula function in Google Sheets to add a strikethrough to specific cells when a checkbox is checked.
The following example...
Google Sheets
Google Sheets: Use an IF Function with 3 Conditions
You can use the following formulas to create an IF function with 3 conditions in Google Sheets:
Method 1: Nested IF Function
=IF(C215, "Bad", IF(C220, "OK",...
Google Sheets
Google Sheets: How to Chart Data from Multiple Sheets
You can easily chart data from multiple sheets in Google Sheets by simply adding multiple ranges for Series in the Chart editor panel.
The following...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read