-
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
STREAK
STREAK will look at a range, and given a value, will return how many consecutive times the value appears in the range.
0
Votes
MAPRANGE
MAPRANGE takes the min and max values of a given range of numbers and converts an input value to a new range of numbers.
0
Votes
0
Votes
VYPER
Extrudes a given Vector by means of all cyclic permutations (the cyclic sequence is invariant).
0
Votes
SPLITTER
SPLITTER splits a text string into pieces based on a delimiter, using a recursive lambda
0
Votes
FREQUENCY_BINS
Returns data_array binned by row to match native FREQUENCY function
0
Votes
0
Votes
AIF
Array Include argument for FILTER function, compact, complex calculations with boolean logic for an array of criteria. NEW!! REDUCE
0
Votes
0
Votes
0
Votes
0
Votes
ACCUMULATE
Applies a set of functions consecutively to a seed value a prescribed number of times.
