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
ALFCR
Array Last or First values, by Columns or Rows, blanks excluded
Replies
0
Views
657
0 Votes
ASUBTOT
array subtotal, inserts sum subtotal rows, every n-th rows of an array
Replies
0
Views
628
0 Votes
DISTINCTCOUNTCOLUMNVISIBLECELLS
Count the visible unique elements in a ColumnVector, regardless of their frequencies. Works only on a ColumnVector.
Replies
6
Views
860
0 Votes
ARUNTOT
array running total, 3 ways
Replies
0
Views
649
0 Votes
ASUBARRAYS
extracts subarrays of an array
Replies
1
Views
644
0 Votes
SUBARRAYS
Recursively traverse an array from top-to-bottom, left-to-right, extracting subarrays with provided dimensions
Replies
1
Views
1K
0 Votes
ALINEARSYS
solves any system of linear equations
Replies
0
Views
590
0 Votes
DISTINCTCOUNT
Count the unique elements in an Array, regardless of their frequencies.
Replies
0
Views
614
0 Votes
DIAGARRAY
Extract the diagonal part of an array.
Replies
0
Views
489
0 Votes
LOWERARRAY
Extract the lower part of an array (below the diagonal).
Replies
0
Views
454
0 Votes
UPPERARRAY
Extract the upper part of an array (above the diagonal).
Replies
0
Views
431
0 Votes
CONSTANTARRAY
Create an array of the specified dimensions where all cells have the specified constant value.
Replies
0
Views
516
0 Votes
ROT90CCW
Rotate an Array 90 degrees Counter ClockWise.
Replies
0
Views
482
0 Votes
ROT90CW
Rotate an Array 90 degrees ClockWise.
Replies
0
Views
477
0 Votes
FLIPARRAYH
Flip array horizontally, left to right.
Replies
0
Views
571
0 Votes
PUTCELL
Put a single value at a precise position in an array. If you try to put the value outside of the array or omit one or both the co-ordinates, the Array remains unchanged.
Replies
0
Views
500
0 Votes
PUTCOLUMN
In an Array put a ColumnVector on a specific ColumnNumber.
Replies
0
Views
438
0 Votes
PUTROW
In an Array put a RowVector on a specific RowNumber.
Replies
0
Views
475
0 Votes
AGGREGATECOLUMNS
Calculate the aggregated values for all columns in an array. The result is a row of aggregated values.
Replies
0
Views
491
0 Votes
AGGREGATEROWS
Calculate the aggregated values for all rows in an array. The result is a column of aggregated values.
Replies
0
Views
479

Forum statistics

Threads
1,226,730
Messages
6,192,708
Members
453,748
Latest member
akhtarf3

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