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
ACCUMULATE
Applies a set of functions consecutively to a seed value a prescribed number of times.
Replies
0
Views
816
0 Votes
AVALUE
AVALUE converts yes's/TRUE's to 1's, no's/FALSE's to 0's, empty cells to a value, errors to a value, numbers stored as text to numbers, and leaves text alone.
Replies
2
Views
624
0 Votes
APPLYN
Applies a function to itself a prescribed number of times
Replies
0
Views
645
0 Votes
IFYESNO
IFYESNO is like IFERROR for Yes and No. It returns Value_If_Yes for Yes cells, Value_If_No for No cells, and the array itself otherwise. Uses ISOMITTED!
Replies
0
Views
575
0 Votes
ATRIM
ATRIM combines TRIM and CLEAN and removes all extra delimiters in text strings (like TRIM for spaces) and removes all non-printing characters listed in CLEAN.
Replies
1
Views
812
0 Votes
AKEEP
keeps only certain chars of an array, all the others are removed and replaced with a delimiter or not
Replies
5
Views
926
0 Votes
AFUSBYROW
Array Filter Unique Sort By Rows
Replies
2
Views
1K
0 Votes
ATOCODES
ATOCODES returns an array of individual character codes from a one dimensional array of text strings with an option to remove non-printing characters.
Replies
1
Views
550
0 Votes
ATOCHARS
ATOCHARS returns an array of individual characters from a one dimensional array of text strings with an option to remove non-printing characters.
Replies
1
Views
640
0 Votes
AONEDIM
Checks if an array is one dimensional and returns "H", "V", or an error message.
Replies
2
Views
572
0 Votes
ATRIM
array TRIMs by any delimiter, and/or CLEANs non pintables char, replaces CHAR(160) with space
Replies
2
Views
922
0 Votes
T_CHARS
tool lambda to select chars useful in recursive text manipulation formulas
Replies
1
Views
699
0 Votes
IFTEXT
IFTEXT is like IFERROR for text. It returns Value_If_Text for text cells and the array itself otherwise.
Replies
0
Views
697
0 Votes
ARESIZE
ARESIZE resizes an array given the number of rows and/or columns to add or remove and values to use for new rows/columns.
Replies
3
Views
586
0 Votes
ASTACK
new!! Stacks an array for a certain width
Replies
5
Views
926
0 Votes
ATEXTJOIN
ATEXTJOIN appends horizontally each row of an array, adds leading string or not, we can set start index, with delimiter or not.
Replies
8
Views
1K
0 Votes
ASTACK
ASTACK stacks or unstacks an array going row by row or column by column given a number of columns.
Replies
0
Views
623
0 Votes
AHCLEAN
Replaces errors with null strings and filters all the rows depending on nr. of blnks/null strings on each row. !!NEW!! BYROW
Replies
3
Views
843
0 Votes
AINDEXER
AINDEXER returns all relative row numbers for each column or all relative column numbers for each row in an array. Uses MAKEARRAY!
Replies
0
Views
477
0 Votes
APP2H
APPends 2 arrays Horizontally, 2nd array column index and offset functionality. !! NEW !! MAKEARRAY , SCAN
Replies
2
Views
693

Forum statistics

Threads
1,226,771
Messages
6,192,926
Members
453,767
Latest member
922aloose

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