-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel LAMBDA Functions
Have you written a useful LAMBDA function that might be useful to others? Post it in the forum. The community can vote for their favorites and we'll suggest to the Excel developers ideas that could be added to the core Excel functions.
* Required to be an active member who has more than 50 posts to submit functions.
* Required to be an active member who has more than 50 posts to submit functions.
0
Votes
AUNQSRT
AUNQSRT sorts ascending, descending, or extracts unique values by rows of an array, left aligned.
0
Votes
1
Vote
REPLACESTRINGS
REPLACESTRINGS bulk replaces matched substrings from one list with corresponding entries in a 2nd list.
0
Votes
LAMBDA.EVALUATE
LAMBDA.EVALUATE is equivalent to the old Excel 4.0 macro EVALUATE with some limitations.
0
Votes
PRETTYPRINT
PRETTYPRINT inserts new lines and indents based on depth with respect to opening and closing bracket characters (parentheses () and curly braces {}) and commas.
0
Votes
TEXTSPLIT
TEXTSPLIT splits an array of text values by a specified delimiter (like text to columns, or vba split function), allowing the user to select Nth split occurrence(s).
0
Votes
COMBINEARRAYS
COMBINEARRAYS combines two 2D arrays into a stacked 2D array, horizontally or vertically, allowing for a default where one array is larger than the other.
0
Votes
TOC2HTML
TOC2HTML creates the table of contents HTML code by transforming the provided list to an HTML list element to be used in the book's HTML page.
0
Votes
SUMCUMULATIVE
SUMCUMULATIVE returns the cumulative sum array of a single array of numbers.
0
Votes
ARRAY1DTO2D
ARRAY1DTO2D Splits a 1D array into a 2D array of equal heights given a divisor.
0
Votes
RESIZEARRAY
RESIZEARRAY resizes an array to a given number of rows and columns, allowing for a default value where columns and rows are out-with the original array.
0
Votes
RIGHTARRAY
RIGHTARRAY returns the right n columns (or rows, or both) of an array.
