Google Sheets
Google Sheets: How to Filter IMPORTRANGE Data
You can use the IMPORTRANGE function in Google Sheets to import data from another spreadsheet.
To apply a filter to the IMPORTRANGE function, you can...
Google Sheets
How to Filter Cells by Color in Google Sheets (With Example)
You can use the Filter by color function in Google Sheets to filter the cells in a range in Google Sheets based on their...
Google Sheets
Google Sheets: Calculate Average If Between Two Dates
You can use the following formula to calculate the average in Google Sheets only for cells that fall between two specific dates:
=AVERAGEIFS(B2:B11, A2:A11, "",...
Google Sheets
How to Extract Year from Date in Google Sheets
You can use the following formula to extract the year from a date in Google Sheets:
=YEAR(A1)
This particular formula will return the year from the...
Google Sheets
Google Sheets: Calculate Average Excluding Outliers
There are two ways to calculate an average while excluding outliers in Google Sheets:
1. Use TRIMMEAN to Exclude Outliers
2. Use Interquartile Range to Exclude...
Google Sheets
Google Sheets: Check if Cell Contains Text from List
You can use the following formula in Google Sheets to check if a cell contains text from a list:
=ArrayFormula(IF(LEN(A2:A13), REGEXMATCH(A2:A13,".*(?i)("&TEXTJOIN("|",
TRUE,$E$2:$E$4)&").*") ,""))
In this example, if...
Google Sheets
How to Convert Days to Months in Google Sheets
You can use the following formula in Google Sheets to convert days to months:
=(B1-A1)/(365/12)
This formula calculates the number of months between cell B1 (the...
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