-
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
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.
0
Votes
0
Votes
ATEXTSPLIT
ATEXTSPLIT splits delimited values from a one dimensional array, or returns the value count, delimiter positions, value positions, or value lengths.
0
Votes
CELLCOUNT
Returns the total cell count, total row count, or total column count of a given range.
0
Votes
CFDATE
CFDATE is used for Conditional Formatting and returns TRUE or FALSE given a function number (1-12) related to dates and a cell reference.
0
Votes
CFLOGIC
CFLOGIC is used for Conditional Formatting and returns TRUE or FALSE given a function number (1-19) related to various logic and a cell reference.
0
Votes
CFMATH
CFMATH is used for Conditional Formatting and returns TRUE or FALSE given a function number (1-16) related to math and a cell reference.
0
Votes
ATTSPLIT
Array To Text Split , splits back to arrays an array of data obtained by ARRAYTOTEXT function, format argument 1
