-
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
PROCESS
PROCESS resizes any input reference into an array/range of any desired size (could be considered as the reverse of LIN/TOROW/TOCOL) with options for output size/style and full control over data type(s) inclusion/exclusion
0
Votes
XUNIQUE
XUNIQUE is a powerful and straightforward alternative to the built-in UNIQUE with full control over data type(s) inclusion/exclusion
0
Votes
0
Votes
STRIM
STRIM is a complete "space" removal solution to conveniently manage leading, trailing, or all spaces within a string
0
Votes
NTIMES
NTIMES returns the values that occur at the specified number of times with full control over data types(s) inclusion/exclusion/replacement
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
LIN
LIN is a powerful array/range linearization alternative to the built-in TOROW/TOCOL with several options and full control over data type inclusion/exclusion
0
Votes
INDEX.Nth
INDEX.Nth returns (every) nth element(s) (starting at the desired position) from a one-dimensional array and provides output options and full control over data type(s) inclusion/exclusion
0
Votes
FLIP
FLIP is a powerful range/array flipping solution with full control over data type(s) inclusion/exclusion in the output
0
Votes
BARCODE(Item,[BCType])
BARCODE generates a Barcode image of data automatically or by specifying any of the 14 available types.
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.TYPE
XERROR.TYPE displays the XTYPE-style error type or error name for all Excel errors
0
Votes
XERROR
XERROR allows for conveniently generating most of the Excel errors as output to functions
0
Votes
LOCAL_YMD
Returns the localized version of YYYY-MM-DD (for a Dutch Windows that's JJJJ-MM-DD, etc.), can be used in TEXT functions.
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.
0
Votes
APIVOT
array pivot, reproduces basic functionality of Pivot Table, with a single cell lambda, for any array, regular, dynamic, table, no refresh needed
