array-formulas

183 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
Split & Transpose challenges
user_170350420
•
1
1
114
array-formulas flatten google-sheets trim split
Using array formula to input single row query on every row
user_85246770
•
3
1
96
array-formulas google-sheets-formula flatten transpose google-sheets
Sum of values generated by ARRAYFORMULA() is incorrect (Google Sheet)
user_173557760
•
1
1
68
array-formulas google-sheets-formula google-sheets filter sum
ultimate short custom number formatting - K, M, B, T, etc., Q, D, Googol
user_56326290
•
10
3
3988
array-formulas google-apps-script google-sheets number-formatting string-formatting
LOOKUP a key range in another key range to get ALL corresponding values, instead of just the first
user_85723820
•
2
2
113
array-formulas google-sheets-formula google-sheets one-to-many lookup
Using Match with Regex and Array formula in Sheets
user_168513830
•
2
3
150
array-formulas transpose google-sheets match regex
Sort data with multiple criteria including MATCH
user_72061910
•
1
1
60
array-formulas google-sheets match sorting arrays
Google Sheets Match/Index Query
user_167010900
•
1
1
73
vlookup array-formulas google-sheets indexing arrays
Google Sheets - Filtering emails from the text in a cell
user_48637000
•
1
1
23
array-formulas google-sheets email-validation arrays regex
Google sheet COUNTA with arrayformula
user_153288840
•
1
3
918
array-formulas google-sheets-formula google-sheets
Hot Questions