-
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
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.
0
Votes
ASEARCH
array search, filters the search/find results of an array "as" within another array "a" according with the search type "st"
0
Votes
T_SF
tool search/find lambda, shows occurrence pattern of searching/finding an array within another array
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
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"
