-
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.
2
Votes
IFANYOF
Functions and predicates to help with ease-of-use/clarity for FILTER include statements
1
Vote
REPEATBYNUMBER
REPEATBYNUMBER takes a range (or table) that has the first column as the item name and the last column as the repeat number then returns a new column of rows with the item names repeated by the required number of times.
1
Vote
REPLACESTRINGS
REPLACESTRINGS bulk replaces matched substrings from one list with corresponding entries in a 2nd list.
1
Vote
PIZZAAREA
PIZZAAREA calculates the number of square inches in a pizza that is N inches in diameter.
1
Vote
0
Votes
INPOLY
INPOLY will return if a given latitude and longitude fall within a polygon. The polygon is a 2 column range/array in order of latitude then longitude.
0
Votes
FILLUP
The value of a next cell is propagated to the null-valued cells below in the columns specified.
0
Votes
FILLDOWN
The value of a previous cell is propagated to the null-valued cells below in the columns specified.
0
Votes
MARKETCAL2
Generate a list of (currently) the ten Holidays the US Stock Market is closed. Can be used to provide the Holiday array for the NETWORKDAYS.INTL and WORKDAY.INTL functions.
0
Votes
PROCESS
PROCESS resizes any input reference into an array/range of any desired size (could be considered as the reverse of LIN/TOROW/TOCOL) with options for output size/style and full control over data type(s) inclusion/exclusion
