Google Sheets
Google Sheets: How to Find Duplicates in Two Columns
Often you may want to find duplicate values across two columns in Google Sheets.
Fortunately this is easy to do using conditional formatting along with...
Google Sheets
How to Count Duplicates in Google Sheets (With Example)
Often you may want to count duplicate values in Google Sheets.
Fortunately this is easy to do using the COUNTIF() function.
The following example shows how...
Google Sheets
Google Sheets: Use CONCATENATE with a Space
You can use the following basic syntax to concatenate strings with a space in Google Sheets:
=CONCATENATE(A2, " ", B2)
This particular formula will concatenate the...
Google Sheets
Google Sheets: How to Convert Minutes to Hours
Often you may want to convert minutes to hours in Google Sheets.
Fortunately this is easy to do and this tutorial explains how to make...
Google Sheets
Google Sheets: How to Exclude Cell from Range in Formulas
You can use the following basic syntax to exclude a cell from a range when using a formula in Google Sheets:
=SUM(FILTER(B2:B11,B2:B11B5))
This particular formula will...
Google Sheets
How to Remove Substring in Google Sheets (With Example)
You can use the following formulas to remove specific substrings from cells in Google Sheets:
Method 1: Remove One Substring from Cell
=SUBSTITUTE(A2,"this_string","")
Method 2: Remove Multiple...
Google Sheets
How to Count Specific Words in Google Sheets
You can use the following formula to count the occurrence of a specific word in Google Sheets:
=COUNTIF(B2:B15, "*Guard*")
This particular formula will count the number...
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