-
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
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.
0
Votes
0
Votes
DISTINCTCOUNTCOLUMNVISIBLECELLS
Count the visible unique elements in a ColumnVector, regardless of their frequencies. Works only on a ColumnVector.
0
Votes
SUBARRAYS
Recursively traverse an array from top-to-bottom, left-to-right, extracting subarrays with provided dimensions
