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
AGGREGATEROWS
Calculate the aggregated values for all rows in an array. The result is a column of aggregated values.
Replies
0
Views
502
0 Votes
TOMORROW
TOMORROW returns the serial number of tomorrow's date.
Replies
4
Views
577
0 Votes
AANAGRAM
finds anagrams matches between 2 arrays
Replies
0
Views
558
0 Votes
AMIN,AMAX
calculates MIN or MAX for each row of an array
Replies
4
Views
1K
0 Votes
ASEARCH
array search, filters the search/find results of an array "as" within another array "a" according with the search type "st"
Replies
0
Views
592
0 Votes
T_SF
tool search/find lambda, shows occurrence pattern of searching/finding an array within another array
Replies
0
Views
497
0 Votes
ASELECT
array select, selects a region of an array between 2 rows, 2 columns, can append extra columns
Replies
0
Views
832
0 Votes
NUMTEXT
NUMTEXT leaves text including blanks alone, converts yes's/true's to 1's, no's/false's to 0's, and converts numbers stored as text to numbers
Replies
0
Views
836
0 Votes
AFLATTEN
AFLATTEN extracts any array in a column array (vertical), does keep the blanks.
Replies
5
Views
1K
0 Votes
AAND, AOR
returns AND or OR values for each row of an array
Replies
0
Views
531
0 Votes
AINSERT
AINSERT, array insert, inserts any string delimiter "d" between characters of an array "a" with a selectable pace "p" and selectable starting point "i".
Replies
7
Views
767
0 Votes
AOCREPLACE
AOCREPLACE, array occurrences replace, replaces only certain occurrences "oc" of a delimiter(any string) "d" in array "a", with a replacement delimiter(any string) "rd"
Replies
1
Views
547
0 Votes
T_APPNAR
T_APPNAR tool formula, a LAMBDA that writes other explicit LAMBDA for appending N arrays horizontally of vertically.
Replies
4
Views
766
0 Votes
T_FREEDAYS
T_FREEDAYS optional tool formula for ACALENDAR to easily replace your free days array(holidays) argument (h) for the entire year.
Replies
1
Views
505
0 Votes
APPENDNHV
APPENDNHV appends N arrays horizontally or vertically.
Replies
0
Views
702
0 Votes
APPEND2V
APPEND2V appends 2 arrays vertically.
Replies
0
Views
1K
0 Votes
APPEND2H
APPEND2H appends 2 arrays horizontally.
Replies
0
Views
945
0 Votes
ACLEAN
ACLEAN cleans an array, replaces errors with null strings or removes the rows with errors or removes the rows with errors and blanks.
Replies
0
Views
773
0 Votes
ASTACK
ASTACK stacks an array.
Replies
0
Views
763
0 Votes
AUNSTACK
AUNSTACK unstacks an array.
Replies
0
Views
730

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