-
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
ASUMIFS
sumifs alternative, that can handle array calculations as its arguments, reports friendly
0
Votes
ACLMJOIN
textjoins chosen pattern of columns indexes of an array, by a delimiter "d", and inserts the result after the "ni" new column index of remaining array
0
Votes
0
Votes
RANDDATA
RANDDATA Creates a 2D array (of n rows) of random data from a 2D array of fields/dimension data.
0
Votes
AFORMULATEXT
AFORMULATEXT improves FORMULATEXT and returns a cell's formula as well as the cell's address or a message for non-formula cells.
0
Votes
NOTERROR
NOTERROR returns TRUE or FALSE if a cell in a given range is not an error.
0
Votes
NOTBLANK
NOTBLANK returns TRUE or FALSE if a cell in a given range is not blank.
0
Votes
ACOUNTIFS
countifs alternative, that can handle array calculations as its arguments, reports friendly
0
Votes
T_IFS
tool-recursive lambda that creates pattern array used in MMULT formula construction as only alternative to SUMIFS COUNTIFS
0
Votes
ACOMBINE
list all possible combinations between all unique elements found on each column of an array
0
Votes
0
Votes
0
Votes
0
Votes
0
Votes
0
Votes
T_AFM
creates pattern array, like "include" argument found in FILTER function of any array, for explicit criteria or comparative arguments, using boolean multiplication (AND)
0
Votes
T_AFA
creates pattern array, like "include" argument found in FILTER function of any array, for explicit criteria or comparative arguments, using boolean adding (OR)
0
Votes
GETONDELIMITER
GETONDELIMITER: Get the nth element after splitting a text string on a delimiter. If the Number is omitted, all elements will be given.
0
Votes
SPLITONDELIMITER
Split a tekst string based on a delimiter. If the Delimiter is omitted or left blank, the text string remains unchanged.
