Operations in Google Sheets
Google Sheets
How to Use Count Unique IF Function in Google Sheets
You can use the following methods to count unique values based on criteria in Google Sheets:
Method 1: Count Unique Values Based on One Criteria
=COUNTUNIQUEIFS(A2:A10,...
Google Sheets
Google Sheets: Quickly Convert Time to Decimal
You can use the following formula to convert a time to a decimal in Google Sheets:
=HOUR(B2)+(MINUTE(B2)/60) + (SECOND(B2)/3600)
This particular formula converts the time in...
Google Sheets
Google Sheets: Use “Not Equal” in Conditional Formatting
You can use the custom formula function in Google Sheets to apply conditional formatting to cells that are not equal to a specific value.
The...
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...
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