A formula that works with an array as opposed to single data values
I'm trying to recode all the zip code from Column A into Column B with the formula: =TEXT(A1,"00000") Like …
google-sheets array-formulas google-sheets-formulaWhat would be a good approach to calculate the number of occurrences in a spreadsheet column? Can this be done …
google-sheets google-sheets-formula array-formulasI need to call LINEST in Excel 2011 for Mac, I would say - this was a detective story. My laziness, …
excel macos array-formulas excel-2011I have a spreadsheet with some values in column G. Some cells are empty in between, and I need to …
google-apps-script google-sheets google-sheets-formula array-formulas custom-functionIn Google Spreadsheets, I need to use the COUNTIF function on a range with multiple criteria. So in the table …
regex google-sheets countif google-sheets-formula array-formulasI have an Excel formula reading data from a column. The data in that column is sometimes a date-like format, …
excel worksheet-function array-formulasIn column A I have list of different names. In column B, I have values either 0 or 1. I want to …
excel excel-formula formula pivot-table array-formulasI have the following formula in my B:B column =VLOOKUP(A1;'mySheet'!$A:$B;2;FALSE) It does output in …
excel excel-formula excel-2010 array-formulasHow do I get a nested 'AND' to work inside 'IF' in an array formula? I reduced my problem to …
excel excel-formula array-formulasOkay so I have a Google Form that dumps info into a spreadsheet. On each line I need to have …
google-sheets google-forms array-formulas