11.8 C
London
Thursday, May 15, 2025

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...

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: 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: 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...

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...

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: 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