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
AFLIP
flips an array horizontally and/or vertically
Replies
11
Views
343
0 Votes
AFLIP
AFLIP returns an array in reverse horizontal order, vertical order, or both.
Replies
1
Views
99
0 Votes
AREVERSE
array reverse
Replies
7
Views
245
0 Votes
VYPER
Extrudes a given Vector by means of all cyclic permutations (the cyclic sequence is invariant).
Replies
4
Views
119
0 Votes
FLIPARRAYV
Flip array vertically, top to bottom.
Replies
6
Views
216
0 Votes
ATEXTSPLIT
array text split by any delimiter,(one or more chars), fine-tuned for complex scenarios
Replies
15
Views
768
0 Votes
SPLITTER
SPLITTER splits a text string into pieces based on a delimiter, using a recursive lambda
Replies
0
Views
82
0 Votes
ASCAN
Array SCAN, 3 in 1 function, SCAN by row, by column, by array
Replies
32
Views
751
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
192
0 Votes
WR
Set of functions and study for solving the Word Maze Excel Challenge
Replies
12
Views
231
0 Votes
FREQUENCY_BINS
Returns data_array binned by row to match native FREQUENCY function
Replies
0
Views
58
0 Votes
PIVOT
Simple pivot table using SUMMARIZE
Replies
2
Views
82
0 Votes
SUMMARIZE
Summarizes data table by grouping selected columns and aggregating.
Replies
2
Views
87
0 Votes
THUNKIT
Allows passing values by "storing" them inside a LAMBDA
Replies
1
Views
115
0 Votes
PAIRWISE
Pairwise function application between two arrays.
Replies
0
Views
90
0 Votes
ACOUNT
Study, array self-count/occurrence self-count/unique count , NEW!! MAP , MAKEARRAY
Replies
5
Views
154
0 Votes
IFANYOF
Functions and predicates to help with ease-of-use/clarity for FILTER include statements
Replies
2
Views
149
0 Votes
SCANBYROW
Performs a SCAN(initial_value,row,fn) on each row of array.
Replies
2
Views
181
0 Votes
ARESIZE
Resize an array
Replies
3
Views
155
0 Votes
AMORTIZE
builds amortization table NEW!! SCAN
Replies
8
Views
253

Forum statistics

Threads
1,148,088
Messages
5,744,747
Members
423,898
Latest member
xpax5896

This Week's Hot Topics

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