A formula that works with an array as opposed to single data values
I have some data in a row, say A1 to Z1, and I would like to link to this data …
excel excel-formula transpose formulas array-formulasIn Google Sheets, when using ArrayFormula with AND formula, I don't get the results as it should be. A|B 2|7 …
google-sheets array-formulasI have an array formula that outputs a single value, and I want to give a whole bunch of cells …
excel vba array-formulasWhy doesn't the split formula get expanded over the entire column when I use =arrayformula(split(input!G2:G, ",")) ? I …
split google-sheets array-formulasI need to count a column only if the corresponding cell in another column is a Tuesday. An example image …
excel excel-formula conditional-formatting countif array-formulasI have a simple array formula in excel that doesn't work in the way I wish. In columns A and …
excel max min array-formulasI'm having an issue with a spreadsheet formula that uses the MATCH() function. =IFERROR(IF(LENB(Y2461)<> 0, "Complete", …
excel excel-formula worksheet-function array-formulas excel-matchI've got a spreadsheet which looks like this: A B C D FirstName SurnameName Address UniqueFamilyId --------------------------------------------------------- Abe Black 1 Elm …
google-sheets google-sheets-formula array-formulasI am trying to insert a hyperlink to a cell in a fashion that can be replicated using '=MATCH()" …
google-apps-script google-sheets hyperlink google-sheets-formula array-formulasWhen the results of an Array Formula are numbers, I find it generally easy to find an appropriate method to …
excel excel-formula array-formulas