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
APIVOT
array pivot, reproduces basic functionality of Pivot Table, with a single cell lambda, for any array, regular, dynamic, table, no refresh needed
Replies
41
Views
9K
0 Votes
WR
Set of functions and study for solving the Word Maze Excel Challenge
Replies
46
Views
4K
0 Votes
ARF
DIY Array Recursive Function kit
Replies
54
Views
6K
0 Votes
AXMAS
Happy Holidays everyone!! For the ones who celebrate Xmas, 2 Xmas tree designs.
Replies
35
Views
4K
1 Vote
ACOMB
Extracts all combinations of columns values of an array
Replies
9
Views
2K
0 Votes
THUNKIT
Allows passing values by "storing" them inside a LAMBDA
Replies
5
Views
4K
0 Votes
ISNUMBERS
ISNUMBERS checks if all elements of the reference are numbers and provides a single logical output, with options for checking if the reference is a single number or equal to another set of numbers and extending equality with elements of other data types
Replies
0
Views
210
0 Votes
MSORT
MSORT is a powerful and versatile array sorting solution that allows for sorting all or a subset of the columns (or rows) together or independently as well as having various options for dealing with the unsortables (blanks, logicals, and errors)
Replies
0
Views
135
0 Votes
AXLOOKUP
array XLOOKUP for 2D arrays
Replies
5
Views
2K
0 Votes
ARRANGEMENTS
Combinatorics study, permutations, combinations w or w/o repetitions, all in one function.
Replies
47
Views
6K
0 Votes
XREPEAT
XREPEAT is a powerful/highly versatile repeating and/or stacking solution for repeating single values, rows or columns; or stacking arrays/ranges allowing for filtering out or inserting blank repeats/stacks, partial stacks, or (partial) 'stacks of stacks'
Replies
0
Views
228
0 Votes
MREPEAT
MREPEAT is a powerful repeating solution that spills array elements of any data type at the specified number of counts with the ability to insert blanks and filter out specific elements as well as stacking
Replies
0
Views
137
0 Votes
SREPEAT
SREPEAT is a simple repeating solution that spills repeats, at the specified number of rows and/or columns, of any single value, including errors or blanks, whether or not enclosed in array brackets
Replies
0
Views
126
0 Votes
SEQUENCES
SEQUENCES is a powerful and versatile multi-SEQUENCE solution providing full control over "start" of each sequence as well as each of the "counts" and "steps" and having other useful features such as stacking and sorting
Replies
0
Views
202
0 Votes
ASCAN
Array SCAN, 3 in 1 function, SCAN by row, by column, by array
Replies
133
Views
14K
1 Vote
SCANBYROW
Performs a SCAN(initial_value,row,fn) on each row of array.
Replies
10
Views
3K
0 Votes
ATEXTSPLIT
array text split by any delimiter,(one or more chars), fine-tuned for complex scenarios
Replies
75
Views
8K
0 Votes
INSPECT
INSPECT is a powerful data inspection tool providing a summary of all unique values in the selected range/array along with their counts and data types; several additional type-based details for the specified data type; and the ability to exclude/include t
Replies
2
Views
258
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
19
Views
3K
0 Votes
NTIMES
NTIMES returns the values that occur at the specified number of times with full control over data types(s) inclusion/exclusion/replacement
Replies
6
Views
452

Forum statistics

Threads
1,226,179
Messages
6,189,476
Members
453,549
Latest member
MBenedikt

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