-
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
FREQUENCY_BINS
Returns data_array binned by row to match native FREQUENCY function
0
Votes
0
Votes
0
Votes
AREPLACE
AREPLACE, array replace, replaces all occurrences of "a" found in "ar" with values of "b".
0
Votes
AREMOVE
!! recursive !! array remove, removes certain chars and replace them with a delimiter or not
0
Votes
ACCUMULATE
Applies a set of functions consecutively to a seed value a prescribed number of times.
0
Votes
AVALUE
AVALUE converts yes's/TRUE's to 1's, no's/FALSE's to 0's, empty cells to a value, errors to a value, numbers stored as text to numbers, and leaves text alone.
0
Votes
IFYESNO
IFYESNO is like IFERROR for Yes and No. It returns Value_If_Yes for Yes cells, Value_If_No for No cells, and the array itself otherwise. Uses ISOMITTED!
0
Votes
ATRIM
ATRIM combines TRIM and CLEAN and removes all extra delimiters in text strings (like TRIM for spaces) and removes all non-printing characters listed in CLEAN.
0
Votes
AKEEP
keeps only certain chars of an array, all the others are removed and replaced with a delimiter or not
0
Votes
ATOCODES
ATOCODES returns an array of individual character codes from a one dimensional array of text strings with an option to remove non-printing characters.
0
Votes
ATOCHARS
ATOCHARS returns an array of individual characters from a one dimensional array of text strings with an option to remove non-printing characters.
0
Votes
AONEDIM
Checks if an array is one dimensional and returns "H", "V", or an error message.
