-
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
ASEARCH
array search, filters the search/find results of an array "as" within another array "a" according with the search type "st"
0
Votes
T_SF
tool search/find lambda, shows occurrence pattern of searching/finding an array within another array
0
Votes
ASELECT
array select, selects a region of an array between 2 rows, 2 columns, can append extra columns
0
Votes
NUMTEXT
NUMTEXT leaves text including blanks alone, converts yes's/true's to 1's, no's/false's to 0's, and converts numbers stored as text to numbers
0
Votes
0
Votes
AINSERT
AINSERT, array insert, inserts any string delimiter "d" between characters of an array "a" with a selectable pace "p" and selectable starting point "i".
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.
