-
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
ACLEAN
ACLEAN cleans an array, replaces errors with null strings or removes the rows with errors or removes the rows with errors and blanks.
0
Votes
ATEXTJOIN
ATEXTJOIN appends horizontally each row of an array, adds leading string or not, we can set start index, with delimiter or not.
0
Votes
AUNIQUE
AUNIQUE extracts unique values, horizontal (for each row) left aligned , vertical (for each column) top aligned , all (in a vertical array).
0
Votes
0
Votes
AUNQSRT
AUNQSRT sorts ascending, descending, or extracts unique values by rows of an array, left aligned.
0
Votes
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
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.
