-
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
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!
0
Votes
APP2H
APPends 2 arrays Horizontally, 2nd array column index and offset functionality. !! NEW !! MAKEARRAY , SCAN
0
Votes
APP2V
APPends 2 arrays Vertically, 2nd array row index and offset functionality. !! NEW !! MAKEARRAY
0
Votes
AOVERLAY
Overlapping/[Overlaying] 2 arrays, using a row/column coordinate system. !!NEW!! MAKEARRAY
0
Votes
0
Votes
ACONSTANT
ACONSTANT returns an array of value(s) repeated over a specified number of rows and columns.
0
Votes
AFILL
AFILL replaces all blanks/null strings of an array/array area, with other array values. !! NEW !! MAKEARRAY , SCAN
0
Votes
APUZZLE
Replaces selected areas of an array "a" with other array "b" values , from left to right , top to bottom. !! NEW !! MAKEARRAY , SCAN
0
Votes
IFNUMBER
IFNUMBER is like IFERROR for numbers. It returns Value_If_Number for number cells and the array itself otherwise.
0
Votes
IFBLANK
IFBLANK is like IFERROR for blanks. It returns Value_If_Blank for blank cells and the array itself otherwise.
0
Votes
NOTTEXT
NOTTEXT returns TRUE or FALSE if a cell in a given range is not text.
0
Votes
NOTNUMBER
NOTNUMBER returns TRUE or FALSE if a cell in a given range is not a number.
