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
LOCAL_YMD
Returns the localized version of YYYY-MM-DD (for a Dutch Windows that's JJJJ-MM-DD, etc.), can be used in TEXT functions.
Replies
9
Views
146
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
ARANDBETWEEN
Random Numbers. Functions. Nonrandomness of random numbers.
Replies
12
Views
3K
0 Votes
APIVOT
array pivot, reproduces basic functionality of Pivot Table, with a single cell lambda, for any array, regular, dynamic, table, no refresh needed
Replies
36
Views
6K
0 Votes
BASE64ENCODE
Encodes string with Base64 encoding.
Replies
12
Views
876
0 Votes
BASE64DECODE
Decodes Base64 encoded string
Replies
2
Views
217
0 Votes
ASCAN
Array SCAN, 3 in 1 function, SCAN by row, by column, by array
Replies
125
Views
11K
0 Votes
ARF
DIY Array Recursive Function kit
Replies
48
Views
4K
0 Votes
AXMAS
Happy Holidays everyone!! For the ones who celebrate Xmas, 2 Xmas tree designs.
Replies
31
Views
3K
0 Votes
FIBONACCI
calculates the nth term of a Fibonacci sequence
Replies
53
Views
7K
0 Votes
LASTUSEDCOLUMN
LASTUSEDCOLUMN returns the last column with an entry in the current sheet.
Replies
11
Views
2K
0 Votes
LASTUSEDROW
LASTUSEDROW returns the last row with an entry in the current sheet.
Replies
1
Views
810
0 Votes
AUNSTACK
new!! Unstacks an array for a certain height. !!NEW!! MAKEARRAY
Replies
9
Views
2K
0 Votes
THUNKIT
Allows passing values by "storing" them inside a LAMBDA
Replies
4
Views
4K
0 Votes
BINGO
BINGO returns a 75 ball Bingo card
Replies
8
Views
927
1 Vote
SLUGIFY.PLUS
SLUGIFY.PLUS function converts the given string to a URL slug.
Replies
7
Views
2K
0 Votes
AXLOOKUP
array XLOOKUP for 2D arrays
Replies
3
Views
2K
0 Votes
INPOLY
INPOLY will return if a given latitude and longitude fall within a polygon. The polygon is a 2 column range/array in order of latitude then longitude.
Replies
1
Views
471
0 Votes
LEFTARRAY
LEFTARRAY returns the LEFT N columns (or rows or both) of an array.
Replies
3
Views
667
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
33
Views
5K

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