google-sheets-formula tutorials

Google Query - "NOT LIKE" Statement Doesn't work

Oct 22, 2022

VLOOKUP within IMPORTRANGE

May 13, 2022

google-sheets google-sheets-formula google-sheets-query gs-vlookup importrange

Convert numbers in Google Sheets to Text / Words

Jul 16, 2022

google-apps-script google-sheets google-sheets-formula

Possible to use Google Spreadsheet functions in Google App Script?

Nov 05, 2022

google-apps-script google-sheets google-sheets-formula google-finance

Is it possible to set a default value of zero when using COUNTA function in Google Sheets?

Sep 24, 2022

google-sheets google-sheets-formula array-formulas

Google finance as an argument for ArrayFormula

Sep 19, 2022

google-apps-script google-sheets google-sheets-formula array-formulas google-finance

Multiple criteria for sumif in Google Sheets

Oct 22, 2022

google-sheets google-sheets-formula array-formulas

Google Sheets filename in cell via formula instead of a script?

Aug 27, 2022

function google-apps-script google-sheets scripting google-sheets-formula

Sum values of columns into adjacent column

Nov 05, 2022

google-sheets sum google-sheets-formula

How to get font color of cell in Google Sheets?

Sep 15, 2022

google-apps-script google-sheets google-sheets-formula

Is there a Google Sheets or MS Excel formula to convert a column with JSON array to multiple rows

Jul 02, 2022

json regex google-sheets google-sheets-formula array-formulas

How to filter one list of items from another list of items?

Aug 26, 2022

filter google-sheets google-sheets-formula

How to SUM duration in Google Sheets?

Sep 14, 2022

google-sheets time sum google-sheets-formula duration

QUERY using cell contents as SQL variables

Sep 09, 2022

google-sheets google-sheets-formula google-sheets-query

Simple way to choose random cell from a list in Google Sheets

May 21, 2022

random indexing google-sheets google-sheets-formula

How do you count cells with a certain partial string?

Oct 31, 2022

string google-sheets count wildcard google-sheets-formula

How do I return multiple columns of data using ImportXML in Google Spreadsheets?

Feb 26, 2022

xpath google-sheets google-sheets-formula google-sheets-importxml

XPath to get all text in element as one value, removing line breaks

May 01, 2021

xpath google-sheets xml-parsing google-sheets-formula google-sheets-importxml

New posts in google-sheets-formula