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.

0 Votes
SPELLNUMBER
SPELLNUMBER takes a number and converts it to spelled out words
Replies
10
Views
2K
0 Votes
XRNG
XRNG will return a sequence given a start, end, and step argument
Replies
0
Views
497
0 Votes
FILLUP
The value of a next cell is propagated to the null-valued cells below in the columns specified.
Replies
0
Views
535
0 Votes
FILLDOWN
The value of a previous cell is propagated to the null-valued cells below in the columns specified.
Replies
2
Views
670
0 Votes
STRIM
STRIM is a complete "space" removal solution to conveniently manage leading, trailing, or all spaces within a string
Replies
11
Views
2K
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
Replies
10
Views
1K
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.
Replies
8
Views
767
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.
Replies
8
Views
939
0 Votes
INSERTBLANKS
INSERTBLANKS will insert blank rows between the values of a given range
Replies
17
Views
1K
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.
Replies
2
Views
815
0 Votes
SPLITBYANY
SPLITBYANY will split a text string by all the characters in the second argument
Replies
2
Views
618
0 Votes
SPLITBYGROUP
SPLITBYGROUP splits a range by the values in a given column
Replies
1
Views
569
0 Votes
SPLITBYCASETRANSITION
SPLITBYCASETRANSITION will split text by case transition from lower case to upper case
Replies
3
Views
489
0 Votes
DD2DMS
DD2DMS converts GPS coordinates from Decimal Degrees to Degrees Minutes Seconds
Replies
1
Views
377
0 Votes
DMS2DD
DMS2DD converts GPS coordinates from Degrees Minutes Seconds to Decimal Degrees
Replies
1
Views
441
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
Replies
6
Views
985
0 Votes
AREPORT
builds Array Reports PT style. !! NEW !! BYROW , BYCOL
Replies
11
Views
2K
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
Replies
10
Views
2K
0 Votes
XUNIQUE
XUNIQUE is a powerful and straightforward alternative to the built-in UNIQUE with full control over data type(s) inclusion/exclusion
Replies
1
Views
585
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
Replies
3
Views
435

Forum statistics

Threads
1,216,499
Messages
6,131,012
Members
449,613
Latest member
MedDash99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top