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...
Google Sheets
Google Sheets: Convert Date to Month and Year Format
You can use one of the following formulas to convert a date to a month and year in Google Sheets:
Formula 1: Convert Date to...
Google Sheets
Google Sheets: Use an IF Function with Range of Values
You can use the following formulas to create an IF function with a range of values in Google Sheets:
Method 1: Create IF Function with...
Google Sheets
How to Count by Month in Google Sheets
You can use the following formula to count the number of occurrences by month in Google Sheets:
=SUMPRODUCT(1*(MONTH(A1:A10)=11))
This particular formula counts the number of dates...
Google Sheets
How to Escape Quotes in Google Sheets (With Example)
There are two ways to escape quotes in formulas in Google Sheets:
Method 1: Wrap Quotes Around Quotes
=CONCATENATE("""",A2,"""")
Method 2: Use CHAR(34)
=CONCATENATE(CHAR(34),A2,CHAR(34))
Both of these formulas will...
Google Sheets
Google Sheets: How to Query From Multiple Ranges
You can use the following basic syntax to query from multiple ranges in Google Sheets:
=QUERY({Sheet1!A1:B10; Sheet2!A2:B5})
This particular example will return the cells in 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