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
MP
MAP Expander
Replies
9
Views
787
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
NTHDAYOFMONTH
Return the nth day of a given month
Replies
0
Views
440
0 Votes
AFLAT
"flattens" any array and filters out blanks, null strings, errors
Replies
10
Views
2K
0 Votes
ADATE
replaces only the dates column values of an array with other data types formats, leaving the rest of the array intact
Replies
14
Views
2K
0 Votes
SLUGIFY
SLUGIFY function converts the given string to a URL slug.
Replies
12
Views
6K
0 Votes
SPLITTER
SPLITTER splits a text string into pieces based on a delimiter, using a recursive lambda
Replies
1
Views
2K
2 Votes
IFANYOF
Functions and predicates to help with ease-of-use/clarity for FILTER include statements
Replies
5
Views
2K
0 Votes
AFLIP
flips an array horizontally and/or vertically
Replies
24
Views
3K
0 Votes
ALARGESUM
sums vertical array of large numbers
Replies
12
Views
2K
0 Votes
LARGESUM
sums 2 large numbers
Replies
1
Views
758
0 Votes
AAGGREGATE
array aggregate by each row of an array, 13 various functions
Replies
1
Views
1K
0 Votes
WR
Set of functions and study for solving the Word Maze Excel Challenge
Replies
36
Views
3K
0 Votes
ACALENDAR
ACALENDAR or month calendar, for any date, displays icons next to the day, icons for matching 2 other date sets, holidays, and other dates.
Replies
13
Views
2K
0 Votes
ARESIZE
Resize an array
Replies
4
Views
1K
0 Votes
AUNICHAR
function to visualize icons, emojis or symbols next to their Unicode values
Replies
3
Views
1K
0 Votes
AFLIP
AFLIP returns an array in reverse horizontal order, vertical order, or both.
Replies
1
Views
675
0 Votes
AREVERSE
array reverse
Replies
7
Views
1K
0 Votes
VYPER
Extrudes a given Vector by means of all cyclic permutations (the cyclic sequence is invariant).
Replies
4
Views
776
0 Votes
FLIPARRAYV
Flip array vertically, top to bottom.
Replies
6
Views
795

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