Search code examples
TEXTSPLIT combined with BYROW returns an unexpected result when using an array of strings as input...


arraysexcelexcel-formulaexcel-lambda

Read More
Lambda function calling another lambda function in Excel?...


excel-lambda

Read More
Excel dynamically calculate cost of products based on bill of materials (BOM) and purchase price his...


exceloffice365dynamic-arraysexcel-lambda

Read More
Excel - How can we replace multiple characters or whole words in a cell using LAMBDA()...


excellambdaexcel-formulaoffice365excel-lambda

Read More
How can I get this LAMBDA function to accept an array as input?...


arraysexcelexcel-formulalevenshtein-distanceexcel-lambda

Read More
Excel, Expand multiple ranges in one array formula...


excelexcel-formulaexcel-lambda

Read More
Repeat a range a number of times...


excelexcel-formularepeatexcel-lambda

Read More
In Office365 Excel, how to define a named lambda function without using the Name Manager "Refer...


exceloffice365excel-lambda

Read More
Understanding Excel lambda...


excellambdaexcel-formulaoffice365excel-lambda

Read More
Excel - Working with incremental numbers, series (summing, finding values, etc)...


excelexcel-formulaexcel-lambda

Read More
Extended: How to adjust this LAMBDA Excel formula to result multiple columns of price data?...


excellambdaexcel-formulamultiple-columnsexcel-lambda

Read More
How can I fix this Excel LAMBDA formula to result all SKUs and prices, type of Unpivot formula...


excellambdaexcel-formulaunpivotexcel-lambda

Read More
Excel: #CALC! error (Nested Array) when using MAP functions for counting interval overlaps...


arraysexcelexcel-formulaexcel-lambda

Read More
ByCol conditional Lambda...


excelexcel-formulaconditional-statementsexcel-lambda

Read More
Increment numbers when value changes in another column...


excellambdaexcel-formulaexcel-lambda

Read More
Excel function UNIQUE is not working on MAKEARRAY and on RANDARRAY (multi-dimension array)...


arraysexcelexcel-formulauniqueexcel-lambda

Read More
Automatically add a number of row cells and subtract a 3rd row over a variable number of columns in ...


excelexcel-formulaexcel-lambda

Read More
Calculate production capacity per product/day up to goal...


excelexcel-formulaletexcel-lambda

Read More
Makearray function in Office Excel unable to generate proper amount of columns for the array...


arraysexcelexcel-formulaexcel-lambda

Read More
Formula to automatically subtract and multiply two rows over a variable number of columns...


excelexcel-formulamultiplicationsubtractionexcel-lambda

Read More
Including additional table columns into Let function constructed table with the ability to sort base...


excelexcel-formulaletexcel-lambda

Read More
Limit the number of results when using Excel array functions...


excelexcel-formulaoffice365excel-lambda

Read More
Advanced problem of finding minimum sum of N consecutive numbers with a twist...


excelexcel-formulaoffice365formulaexcel-lambda

Read More
Create an array of the dates of the last X times something happened, including duplicates...


arraysexcelexcel-formulaexcel-lambda

Read More
Create an array from hard-coded values for use in a LAMBDA function...


excelexcel-formulaexcel-lambda

Read More
Is it possible to step through a row of data and sum every n-th cell using a Lambda function?...


excelloopslambdaexcel-formulaexcel-lambda

Read More
INDIRECT and OFFSET in the function body make a name special...


excellambdaexcel-formulaexcel-lambda

Read More
Recursive LAMBDA to replace characters by specific substitutes from a lookup table...


excellambdaexcel-formulaexcel-lambda

Read More
Can "Match Mode" functionality be created within a LAMBDA function in Excel?...


excellambdaexcel-formulaexcel-lambda

Read More
How to share generic LAMBDA-functions over different projects?...


excelexcel-formulaexcel-lambda

Read More
BackNext