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
ROWNUMBERS
ROWNUMBERS returns an array of the row numbers of a 2D array.
Replies
0
Views
687
0 Votes
TEXTTOARRAY
TEXTTOARRAY Returns an array of single characters from a 1D array of text strings.
Replies
0
Views
2K
0 Votes
BLACK.SCHOLES
BLACK.SCHOLES calculates the price of an option using the Black & Scholes option pricing formula.
Replies
0
Views
3K
0 Votes
KTHCHARINSTANCE
KTHCHARINSTANCE finds the nth occurrence of a character.
Replies
12
Views
2K
0 Votes
REVERSE
REVERSE returns the contents of the given text with all the characters reversed.
Replies
2
Views
2K
0 Votes
MILESBETWEENCITIES
MILESBETWEENCITIES calculates the miles between two geography data types. Each data type must support the latitude and longitude field.
Replies
0
Views
872
1 Vote
PIZZAAREA
PIZZAAREA calculates the number of square inches in a pizza that is N inches in diameter.
Replies
0
Views
857
1 Vote
HYPOTENUSE
HYPOTENUSE is used to calculate the length of the hypotenuse of a right triangle.
Replies
0
Views
909
0 Votes
FULLCASES
FULLCASES is essentially the ROUNDUP version of MROUND.
Replies
0
Views
753
0 Votes
YESTERDAY
YESTERDAY function returns the serial number of yesterday's date.
Replies
0
Views
788

Forum statistics

Threads
1,224,836
Messages
6,181,251
Members
453,027
Latest member
Lost_in_spreadsheets

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