A formula that works with an array as opposed to single data values
I would like to aggregate the data of multiple spreadsheets into one spreadsheet. Spreadsheet 1 has a Row of Strings A2:…
google-sheets google-sheets-formula array-formulas importrangeIn Google spreadsheets, I need a formula to extract all digits (0 to 9) contained into an arbitrary string, that might contain …
regex google-sheets extract google-sheets-formula array-formulasI'm using VBA, and I need to insert an array formula (the one that if I'm writing it manually, I'll …
vba excel excel-formula array-formulasUsually don't need help with sheets but I think my brain is imploding from thinking on this too much. Trying …
google-sheets sumifs array-formulasExample: ID Value MAX Group1 2 6 Group1 4 6 Group1 6 6 Group2 1 3 Group2 3 3 Group3 7 8 Group3 4 8 Group3 2 8 Group3 8 8 Group4 1 3 Group4 2 3 Group4 3 3 Group5 7 7 The column 'MAX' …
excel excel-formula pivot-table array-formulas vbaI tried to use the MATCH function in an array formula to return multiple matches (by default it only returns …
excel vba array-formulas excel-matchI have a Google spreadsheet with basically a dictionary of key/value pairs. Keys are unique. In a second sheet …
google-sheets array-formulas gs-vlookupI am looking for a simple way in Excel to calculate with units of different values. I have a list …
excel excel-formula excel-2013 array-formulasI have a table: A | B | C BEN | MOSKOW | YES ANTON | IRKUTSK | NO VIKTOR | PARIS | YES BEN | PARIS | YES ANTON | …
google-sheets transpose array-formulas google-sheets-queryI have an exported list of bank transactions in Excel, which I'd like to categorize as quickly and simply as …
excel array-formulas