-
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
MATCHES
MATCHES is a powerful enhancement to the Excel's built-in MATCH function and returns the relative positions of all items in a one-dimensional array that match a specified value
0
Votes
ISXTYPE
ISXTYPE, companion to XTYPE, is a powerful alternative to Excel's built-in type-based conditional functions such as ISNUMBER, ISTEXT, etc., while packing other useful features as well
0
Votes
XTYPE
XTYPE outputs the precise data type of a cell/range or the elements of an array beyond the resolution of Excel's TYPE() or CELL("type",)
0
Votes
XERROR
XERROR allows for conveniently generating most of the Excel errors as output to functions
0
Votes
CONTRAST
CONTRAST returns the contrast ration between 2 colors. The range of values returned is from 0-21 with 21 being the highest contrast value.
0
Votes
STRIM
STRIM is a complete "space" removal solution to conveniently manage leading, trailing, or all spaces within a string
0
Votes
MC
MC allows for conveniently selecting multiple discontinuous cells as a single parameter within the syntax of formulas
0
Votes
STREAK
STREAK will look at a range, and given a value, will return how many consecutive times the value appears in the range.
0
Votes
MAPRANGE
MAPRANGE takes the min and max values of a given range of numbers and converts an input value to a new range of numbers.
1
Vote
REPEATBYNUMBER
REPEATBYNUMBER takes a range (or table) that has the first column as the item name and the last column as the repeat number then returns a new column of rows with the item names repeated by the required number of times.
