-
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
ARRAY1DTO2D
ARRAY1DTO2D Splits a 1D array into a 2D array of equal heights given a divisor.
0
Votes
RESIZEARRAY
RESIZEARRAY resizes an array to a given number of rows and columns, allowing for a default value where columns and rows are out-with the original array.
0
Votes
RIGHTARRAY
RIGHTARRAY returns the right n columns (or rows, or both) of an array.
0
Votes
TEXTTOARRAY
TEXTTOARRAY Returns an array of single characters from a 1D array of text strings.
0
Votes
BLACK.SCHOLES
BLACK.SCHOLES calculates the price of an option using the Black & Scholes option pricing formula.
0
Votes
TEXTSPLIT
TEXTSPLIT splits an array of text values by a specified delimiter (like text to columns, or vba split function), allowing the user to select Nth split occurrence(s).
0
Votes
LASTUSEDROW
LASTUSEDROW returns the last row with an entry in the current sheet.
0
Votes
KTHCHARINSTANCE
KTHCHARINSTANCE finds the nth occurrence of a character.
0
Votes
0
Votes
MILESBETWEENCITIES
MILESBETWEENCITIES calculates the miles between two geography data types. Each data type must support the latitude and longitude field.
