-
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
FILLUP
The value of a next cell is propagated to the null-valued cells below in the columns specified.
0
Votes
FILLDOWN
The value of a previous cell is propagated to the null-valued cells below in the columns specified.
0
Votes
STRIM
STRIM is a complete "space" removal solution to conveniently manage leading, trailing, or all spaces within a string
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
MARKETCAL2
Generate a list of (currently) the ten Holidays the US Stock Market is closed. Can be used to provide the Holiday array for the NETWORKDAYS.INTL and WORKDAY.INTL functions.
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
REPEAT
REPEAT produces an array containing a number of copies of the input range stacked vertically and/or horizontally. The input range can be single or multiple column range.
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
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
XUNIQUE
XUNIQUE is a powerful and straightforward alternative to the built-in UNIQUE with full control over data type(s) inclusion/exclusion
