New post in Array-formulas

Set ArrayFormula to many Excel cells using VBA

June 24th, 2022

find all array formulas in an excel worksheet

June 4th, 2022

How to insert hyperlink to a cell in Google sheet using formula?

June 4th, 2022

Excel min value greater than x returns 0 if no value found?

June 13th, 2022

Categorizing bank transactions in Excel

June 5th, 2022

Set column default value in Google Sheets

June 27th, 2022

iterate row by row COUNTIF using ArrayFormula on Google Sheets

June 18th, 2022

Add title row with ARRAYFORMULA in Google Sheets

June 19th, 2022

How to use ArrayFormula in Google Sheets, with multiple IF conditions?

July 19th, 2022

Calculation with values expressed in different units (KB, MB, GB)

August 21st, 2020

vlookup with multiple columns

October 5th, 2020

How to get min value in a group?

July 9th, 2022

How to use ARRAYFORMULA + FILTER within Google Spreadsheet?

July 6th, 2020

In ARRAY_LITERAL, an Array Literal was missing values for one or more rows - indirect formula error in google spreadsheet

July 19th, 2022

Have formula treat value as text, not numeric

May 23rd, 2020

Make Google Spreadsheet Formula Repeat Infinitely

December 25th, 2020

Extract digits from string - Google spreadsheet

May 17th, 2021

How do I combine COUNTIF with OR

January 18th, 2022

ArrayFormula and "AND" Formula in Google Sheets

July 19th, 2022

Apply formula to the entire column

July 8th, 2022

How do I use a nested IF(AND) in an Excel array formula?

July 19th, 2022

Convert an Array Formula's Text Results into a Usable Format

June 22nd, 2022

What is an equivalent for INDEX in ARRAYFORMULA?

June 4th, 2022

Spreadsheet formula to gather all matches into one cell

June 7th, 2022

How to prefix Plus sign "+" before the number if the value is negative in Google Sheets or MS Excel?

June 5th, 2022

ARRAYFORMULA() does not work with SPLIT()

June 9th, 2022