-
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
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
ATRIM
array TRIMs by any delimiter, and/or CLEANs non pintables char, replaces CHAR(160) with space
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
AREPLACE
AREPLACE, array replace, replaces all occurrences of "a" found in "ar" with values of "b".
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
ACALENDAR
ACALENDAR or month calendar, for any date, displays icons next to the day, icons for matching 2 other date sets, holidays, and other dates.
0
Votes
T_APPNAR
T_APPNAR tool formula, a LAMBDA that writes other explicit LAMBDA for appending N arrays horizontally of vertically.
