-
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
SPLITBYCASETRANSITION
SPLITBYCASETRANSITION will split text by case transition from lower case to upper case
0
Votes
0
Votes
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
MKTDAYS
Provides a list of dates that omits Fridays, Saturdays, and the dates provided by the Hols list of dates. Intended for use with the STOCKHISTORY function.
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
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
FLIP
FLIP is a powerful range/array flipping solution with full control over data type(s) inclusion/exclusion in the output
0
Votes
ISINT
ISINT allows for checking if the reference contains integer value(s) and provides logical output
0
Votes
XERROR.TYPE
XERROR.TYPE displays the XTYPE-style error type or error name for all Excel errors
0
Votes
FSPL
FSPL calculates the 'Free Space Path Loss' for a given frequency, distance, transmitter gain, and receiver gain.
0
Votes
UNPIVOT
Translates a set of columns in a table into attribute-value pairs, combined with the rest of the values in each row
