-
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
AOCREPLACE
AOCREPLACE, array occurrences replace, replaces only certain occurrences "oc" of a delimiter(any string) "d" in array "a", with a replacement delimiter(any string) "rd"
0
Votes
T_APPNAR
T_APPNAR tool formula, a LAMBDA that writes other explicit LAMBDA for appending N arrays horizontally of vertically.
0
Votes
T_FREEDAYS
T_FREEDAYS optional tool formula for ACALENDAR to easily replace your free days array(holidays) argument (h) for the entire year.
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
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.
