You can use the following basic syntax to use the SEARCH function with multiple values in Google Sheets: =FILTER(A2:A10, SEARCH(“Backup”, A2:A10), SEARCH(“Guard”,…
Google Sheets

 Google SheetsOperations in Google SheetsSoftware Tutorials
Google Sheets: How to Use FILTER with Wildcard
by Tutor AspireYou can use the following formula in Google Sheets to use a wildcard character within a FILTER function: =FILTER(A2:C11,search(“avs”,A2:A11)) This particular formula…
 Google SheetsQuery Functions in Google SheetsSoftware Tutorials
Google Sheets: Use IMPORTRANGE Within Same Spreadsheet
by Tutor AspireYou can use the IMPORTRANGE function in Google Sheets to import data from another spreadsheet. However, if you would like to import…
 Google SheetsQuery Functions in Google SheetsSoftware Tutorials
Google Sheets: How to Filter IMPORTRANGE Data
by Tutor AspireYou can use the IMPORTRANGE function in Google Sheets to import data from another spreadsheet. To apply a filter to the IMPORTRANGE…
 Google SheetsOperations in Google SheetsSoftware Tutorials
How to Filter Cells by Color in Google Sheets (With Example)
by Tutor AspireYou can use the Filter by color function in Google Sheets to filter the cells in a range in Google Sheets based…
 Google SheetsOperations in Google SheetsSoftware Tutorials
Google Sheets: Calculate Average If Between Two Dates
by Tutor AspireYou can use the following formula to calculate the average in Google Sheets only for cells that fall between two specific dates:…
 Google SheetsOperations in Google SheetsSoftware Tutorials
How to Extract Year from Date in Google Sheets
by Tutor AspireYou can use the following formula to extract the year from a date in Google Sheets: =YEAR(A1) This particular formula will return…
 Google SheetsOperations in Google SheetsSoftware Tutorials
Google Sheets: Calculate Average Excluding Outliers
by Tutor AspireThere are two ways to calculate an average while excluding outliers in Google Sheets: 1. Use TRIMMEAN to Exclude Outliers 2. Use…
 Google SheetsOperations in Google SheetsSoftware Tutorials
Google Sheets: Check if Cell Contains Text from List
by Tutor AspireYou 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)&”).*”)…
 Google SheetsOperations in Google SheetsSoftware Tutorials
How to Convert Days to Months in Google Sheets
by Tutor AspireYou can use the following formula in Google Sheets to convert days to months: =(B1A1)/(365/12) This formula calculates the number of months…