-
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
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
0
Votes
CONSTANTARRAY
Create an array of the specified dimensions where all cells have the specified constant value.
0
Votes
PUTCELL
Put a single value at a precise position in an array. If you try to put the value outside of the array or omit one or both the co-ordinates, the Array remains unchanged.
0
Votes
AGGREGATECOLUMNS
Calculate the aggregated values for all columns in an array. The result is a row of aggregated values.
0
Votes
AGGREGATEROWS
Calculate the aggregated values for all rows in an array. The result is a column of aggregated values.
