-
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
LOCAL_YMD
Returns the localized version of YYYY-MM-DD (for a Dutch Windows that's JJJJ-MM-DD, etc.), can be used in TEXT functions.
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.
0
Votes
APIVOT
array pivot, reproduces basic functionality of Pivot Table, with a single cell lambda, for any array, regular, dynamic, table, no refresh needed
0
Votes
0
Votes
0
Votes
LASTUSEDROW
LASTUSEDROW returns the last row with an entry in the current sheet.
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.
