A formula that works with an array as opposed to single data values
I have a workbook with 11 sheets for each month, and one summary sheet. On each sheet is a list of …
excel excel-formula worksheet-function array-formulas consolidationI have (what I thought was) a simple lookup table holding some exchange rates. There I am looking up values …
google-sheets google-sheets-formula array-formulas gs-vlookupis there a way to find all array formulas in a given excel spreadsheet?
excel vba array-formulasI watched a tutorial where the author uses an IF statement along with the ARRAYFORMULA function to add a title …
google-sheets google-sheets-api array-formulasI am trying to iterate a COUNTIF formula that counts the number of cells in each row containing numbers greater …
google-sheets spreadsheet countif array-formulasI want to calculate a moving average of the last, say 20, numbers of a column. A problem is that some …
excel vba worksheet-function array-formulasI'm trying to calculate the sum of column in google spreadsheet when DataSheet!G:G="solved" AND DataSheet!C:C="…
google-sheets google-sheets-formula array-formulasI'm using Google sheets for data entry that auto-populates data from my website whenever someone submits to a form. The …
google-sheets array-formulasI've done a lengthy search and couldn't find what I'm looking for. Maybe someone out there can kindly help? I …
google-sheets formulas array-formulas