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
ARRANGEMENTS
Combinatorics study, permutations, combinations w or w/o repetitions, all in one function.
Replies
45
Views
2K
0 Votes
ASCAN
Array SCAN, 3 in 1 function, SCAN by row, by column, by array
Replies
76
Views
4K
1 Vote
ACOMB
Extracts all combinations of columns values of an array
Replies
8
Views
519
0 Votes
GSHEETS
Given the "Anyone with the link" Share URL (SURL) from Google Sheets, provides URL to use in a Web Power Query to retrieve data from the Google Sheet file.
Replies
1
Views
39
1 Vote
SHEETNAME
SHEETNAME returns the parent worksheet name of the reference cell.
Replies
1
Views
1K
0 Votes
RANDOMDATE
RANDOMDATE will return a number of random dates given a range of years.
Replies
13
Views
278
0 Votes
ARF
DIY Array Recursive Function kit
Replies
38
Views
2K
0 Votes
AUNIQUE
AUNIQUE extracts unique values, horizontal (for each row) left aligned , vertical (for each column) top aligned , all (in a vertical array).
Replies
28
Views
1K
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
2
Views
162
0 Votes
XCOUNT
XCOUNT is a powerful cell counting solution to count 'cells in a range' or 'array elements' or rows/columns in ranges/arrays that contain the specified data type (high resolution) and/or meet 'matching criteria'
Replies
2
Views
110
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
1
Views
139
0 Votes
MAKECOMBO
Returns combination of two arrays
Replies
27
Views
722
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
0
Views
128
0 Votes
AINDEXERL
AINDEXERL returns a stack of all relative row numbers for each column or all relative column numbers for each row in an array. Uses MAKEARRAY!
Replies
2
Views
360
0 Votes
XERROR
XERROR allows for conveniently generating most of the Excel errors as output to functions
Replies
0
Views
118
0 Votes
ARANDBETWEEN
Random Numbers. Functions. Nonrandomness of random numbers.
Replies
3
Views
230
1 Vote
ARRANGE
rearranges columns of an array from left to right in any order
Replies
7
Views
857
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
85
0 Votes
STRIM
STRIM is a complete "space" removal solution to conveniently manage leading, trailing, or all spaces within a string
Replies
0
Views
284
0 Votes
ATEXTSPLIT
array text split by any delimiter,(one or more chars), fine-tuned for complex scenarios
Replies
74
Views
4K

Forum statistics

Threads
1,181,178
Messages
5,928,557
Members
436,607
Latest member
MMCP15

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
Top