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
ALARGESUM
sums vertical array of large numbers
Replies
12
Views
2K
0 Votes
LARGESUM
sums 2 large numbers
Replies
1
Views
852
0 Votes
AAGGREGATE
array aggregate by each row of an array, 13 various functions
Replies
1
Views
1K
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
728
0 Votes
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
870
0 Votes
FLIPARRAYV
Flip array vertically, top to bottom.
Replies
6
Views
944
0 Votes
AIF
Array Include argument for FILTER function, compact, complex calculations with boolean logic for an array of criteria. NEW!! REDUCE
Replies
10
Views
1K
0 Votes
FREQUENCY_BINS
Returns data_array binned by row to match native FREQUENCY function
Replies
0
Views
619
0 Votes
PIVOT
Simple pivot table using SUMMARIZE
Replies
2
Views
1K
0 Votes
SUMMARIZE
Summarizes data table by grouping selected columns and aggregating.
Replies
2
Views
1K
0 Votes
PAIRWISE
Pairwise function application between two arrays.
Replies
0
Views
973
0 Votes
ACOUNT
Study, array self-count/occurrence self-count/unique count , NEW!! MAP , MAKEARRAY
Replies
5
Views
1K
0 Votes
AMORTIZE
builds amortization table NEW!! SCAN
Replies
8
Views
2K
0 Votes
AREPLACE
AREPLACE, array replace, replaces all occurrences of "a" found in "ar" with values of "b".
Replies
4
Views
1K
0 Votes
AMORTIZE
Creates a simple amortization schedule
Replies
1
Views
787
0 Votes
AREMOVE
!! recursive !! array remove, removes certain chars and replace them with a delimiter or not
Replies
3
Views
968

Forum statistics

Threads
1,223,526
Messages
6,172,833
Members
452,483
Latest member
Johnstone

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