-
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
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.
0
Votes
ATRIM
array TRIMs by any delimiter, and/or CLEANs non pintables char, replaces CHAR(160) with space
0
Votes
0
Votes
IFTEXT
IFTEXT is like IFERROR for text. It returns Value_If_Text for text cells and the array itself otherwise.
0
Votes
ARESIZE
ARESIZE resizes an array given the number of rows and/or columns to add or remove and values to use for new rows/columns.
0
Votes
ATEXTJOIN
ATEXTJOIN appends horizontally each row of an array, adds leading string or not, we can set start index, with delimiter or not.
0
Votes
ASTACK
ASTACK stacks or unstacks an array going row by row or column by column given a number of columns.
0
Votes
AHCLEAN
Replaces errors with null strings and filters all the rows depending on nr. of blnks/null strings on each row. !!NEW!! BYROW
0
Votes
AINDEXER
AINDEXER returns all relative row numbers for each column or all relative column numbers for each row in an array. Uses MAKEARRAY!
