-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
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.
* Required to be an active member who has more than 50 posts to submit functions.
0
Votes
NOTFOUND
NOTFOUND returns TRUE or FALSE if a cell in a given range does not contain a value.
1
Vote
0
Votes
ARRANGEMENTS
Combinatorics study, permutations, combinations w or w/o repetitions, all in one function.
0
Votes
GSHEETS
Given the "Anyone with the link" Share URL (SURL) from Google Sheets, provides URL to use in a Web Power Query to retrieve data from the Google Sheet file.
0
Votes
AINDEXERL
AINDEXERL returns a stack of all relative row numbers for each column or all relative column numbers for each row in an array. Uses MAKEARRAY!
0
Votes
CONTRAST
CONTRAST returns the contrast ration between 2 colors. The range of values returned is from 0-21 with 21 being the highest contrast value.
0
Votes
ATEXTSPLIT
array text split by any delimiter,(one or more chars), fine-tuned for complex scenarios
0
Votes
MC
MC allows for conveniently selecting multiple discontinuous cells as a single parameter within the syntax of formulas
0
Votes
STREAK
STREAK will look at a range, and given a value, will return how many consecutive times the value appears in the range.
