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
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
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
Replies
2
Views
853
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",)
Replies
3
Views
1K
0 Votes
XERROR
XERROR allows for conveniently generating most of the Excel errors as output to functions
Replies
1
Views
691
0 Votes
ARANDBETWEEN
Random Numbers. Functions. Nonrandomness of random numbers.
Replies
12
Views
3K
0 Votes
RANDOMDATE
RANDOMDATE will return a number of random dates given a range of years.
Replies
16
Views
1K
0 Votes
MAKECOMBO
Returns combination of two arrays
Replies
27
Views
2K
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.
Replies
0
Views
358
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
MC
MC allows for conveniently selecting multiple discontinuous cells as a single parameter within the syntax of formulas
Replies
0
Views
763
0 Votes
ORDINAL
Return the ordinal for a given number
Replies
0
Views
455
0 Votes
STREAK
Largest consecutive distribution of a given value, BYROW or BYCOL
Replies
19
Views
1K
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.
Replies
1
Views
489
0 Votes
INSRWS
Inserts one or more blank rows
Replies
21
Views
2K
0 Votes
INSERTBLANKAT
INSERTBLANKAT function inserts blank cells at every X row in a given range.
Replies
4
Views
710
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.
Replies
0
Views
387
0 Votes
MP
MAP Expander
Replies
9
Views
787
0 Votes
NTHDAYOFMONTH
Return the nth day of a given month
Replies
0
Views
440
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.
Replies
56
Views
5K
0 Votes
AXMAS
Happy Holidays everyone!! For the ones who celebrate Xmas, 2 Xmas tree designs.
Replies
31
Views
3K

Forum statistics

Threads
1,216,503
Messages
6,131,022
Members
449,616
Latest member
PsychoCube

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