array-formulas

183 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
How do I join multi-row & multi-column data with an ARRAYFORMULA (or similar) in Google Sheets?
user_152166490
•
2
2
91
array-formulas google-sheets-formula google-sheets
Exclude current row from VLOOKUP?
user_148671680
•
2
3
542
countif vlookup array-formulas google-sheets-formula google-sheets
regexextract all groups from list as arrayformula
user_149663850
•
3
2
59
re2 array-formulas google-sheets-formula google-sheets regex
Google Sheets: Avoid #DIV/0! In ArrayFormula()
user_1909250
•
2
2
657
array-formulas divide-by-zero google-sheets
Formula to replace 0 with empty cell where F:F used range end
Admin1
•
2
1
95
array-formulas google-sheets-formula google-sheets arrays
ArrayFormula of Average on Infinite Truly Dynamic Range in Google Sheets
user_56326290
•
2
6
1256
google-query-language array-formulas google-sheets-formula google-sheets average
How to create a Google Sheets AND formula that returns an array of TRUEs and FALSEs instead of a singular TRUE or FALSE?
user_110423590
•
2
1
344
array-formulas google-sheets-formula google-sheets
SUM the total in different spreadsheets
user_85552720
•
1
2
45
array-formulas google-sheets-formula google-sheets filter sum
Fill in blank cells in ={ARRAYFORMULA()}
Alexander_Gladysh_62360
•
3
1
587
vlookup nested-if array-formulas google-sheets if-statement
Google sheets - join one value to each value in comma separated list and generate a single list of the results
user_84052350
•
2
2
244
array-formulas google-sheets-formula google-sheets
Hot Questions