array-formulas Examples and Free Source Code

How to VLOOKUP with filtered results...

google-sheets vlookup array-formulas

Increasing a number based on a decimal less than 100?...

google-sheets sum decimal google-sheets-formula array-formulas

Totaling multiple lines into once cell with different date formats...

date google-sheets google-sheets-formula array-formulas google-sheets-query

A custom function for joining cells and an optional value from an adjacent cell in Google spreadshee...

if-statement google-sheets google-sheets-formula array-formulas textjoin

What does asterisk mean in the logical expression of an "IF" function?...

arrays if-statement google-sheets google-sheets-formula array-formulas

ArrayFormula with the sum and multiplication of multiple columns...

arrays google-sheets sum google-sheets-formula array-formulas

How do you extract characters from a string?...

arrays regex google-sheets google-sheets-formula array-formulas

Increment ID# by 1 if Same month ArrayFormula...

if-statement google-sheets google-sheets-formula array-formulas countif

Why is ArrayFormula causing empty value "" to register > 0...

if-statement google-sheets sum google-sheets-formula array-formulas

In Google Sheets, how to transpose multiple column headers and data into a single column of multiple...

google-sheets google-sheets-formula transpose array-formulas google-sheets-query

Possible to use ArrayFormula like Conditional Formatting Custom Formula?...

regex google-sheets google-sheets-formula array-formulas google-sheets-query

Concatenate incrementing row number with string in Google Sheets Arrayformula...

arrays google-sheets concatenation google-sheets-formula array-formulas

IF event has occurred at X location within Y days, return Z value (Excel or Google Sheets)...

if-statement google-sheets excel-formula google-sheets-formula array-formulas

Repeat values using SEQUENCE function in row of dates...

arrays date google-sheets google-sheets-formula array-formulas

Calculating averages using QUERY and INDIRECT...

google-sheets average google-sheets-formula array-formulas google-sheets-query

If a number exists in one column, look up a value in a different column that corresponds with the nu...

arrays google-sheets google-sheets-formula array-formulas gs-vlookup

Extract UTM parameters in Google Sheets...

regex google-sheets google-sheets-formula array-formulas utm-tracking

How to rearrange my data? split and transpose...

arrays google-sheets google-sheets-formula transpose array-formulas

How to join columns in single text with quotation marks, commas and parentheses?...

google-sheets concatenation google-sheets-formula array-formulas google-sheets-query

get values from other cell from other sheet if match value match with other cell...

google-sheets google-sheets-formula array-formulas gs-vlookup

How to arrange data by matching values from other cell...

sorting google-sheets google-sheets-formula array-formulas gs-vlookup

How to extract only date from Google Sheets cell...

regex date google-sheets google-sheets-formula array-formulas

add IMAGE function to only one column of data collected via IMPORTXML...

web-scraping google-sheets array-formulas google-sheets-formula

How to convert dates pulled from IMPORTXML to actual dates...

date google-sheets array-formulas google-sheets-formula

Google Sheets Search and Sum in two lists...

regex google-sheets google-sheets-formula array-formulas google-sheets-query

How to find Curved Grade in Google Sheets?...

arrays if-statement google-sheets google-sheets-formula array-formulas

How to return a value based on whether two columns contains values present in other columns...

regex if-statement google-sheets google-sheets-formula array-formulas

Import Range Dynamically Based On Size...

arrays google-sheets google-sheets-formula array-formulas google-sheets-query

How to convert rows to columns according to the content of a column...

csv google-sheets transpose array-formulas google-sheets-query

Create a pivot table where the resulting columns are the product of the original columns and rows?...

google-sheets pivot transpose array-formulas google-sheets-query