List Question
20 TechQA 2024-03-30T16:52:08.357000Excel dynamically calculate cost of products based on bill of materials (BOM) and purchase price history
57 views
Asked by Ricardo Diaz
How can I get this LAMBDA function to accept an array as input?
111 views
Asked by Ne Mo
Excel, Expand multiple ranges in one array formula
100 views
Asked by Nigel Domaingue
Lambda function calling another lambda function in Excel?
191 views
Asked by Scoodood
Microsoft documents LAMBDA attached to a defined name. Is this possible to create with Openpyxl?
66 views
Asked by Cronical
What prevents a lambda function from evaluating on an array?
379 views
Asked by vladi
Understanding Excel lambda
462 views
Asked by Enzo_c
Calling Excel Add-In functions from within MAP or MAKEARRAY
96 views
Asked by shiftins
Excel - Working with incremental numbers, series (summing, finding values, etc)
153 views
Asked by Martin
Adding a LAMBDA formula forces other users to reopen spreadsheet
80 views
Asked by jeranon
TEXTSPLIT combined with BYROW returns an unexpected result when using an array of strings as input
777 views
Asked by David Leal
Repeat a range a number of times
2.8k views
Asked by vsoler
Extended: How to adjust this LAMBDA Excel formula to result multiple columns of price data?
214 views
Asked by Andy L
How can I fix this Excel LAMBDA formula to result all SKUs and prices, type of Unpivot formula
84 views
Asked by Andy L
How to use Lambda in Excel to return array of results for an array
1.4k views
Asked by Andy L
Excel: #CALC! error (Nested Array) when using MAP functions for counting interval overlaps
970 views
Asked by David Leal
ByCol conditional Lambda
222 views
Asked by Automation Monkey
Repeat values n times where n could also be 0.5
258 views
Asked by P.b