-
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
FLIP
FLIP is a powerful range/array flipping solution with full control over data type(s) inclusion/exclusion in the output
0
Votes
XCOUNT
XCOUNT is a powerful cell counting solution to count 'cells in a range' or 'array elements' or rows/columns in ranges/arrays that contain the specified data type (high resolution) and/or meet 'matching criteria'
0
Votes
ISXTYPE
ISXTYPE, companion to XTYPE, is a powerful alternative to Excel's built-in type-based conditional functions such as ISNUMBER, ISTEXT, etc., while packing other useful features as well
0
Votes
XTYPE
XTYPE outputs the precise data type of a cell/range or the elements of an array beyond the resolution of Excel's TYPE() or CELL("type",)
0
Votes
ISINT
ISINT allows for checking if the reference contains integer value(s) and provides logical output
0
Votes
XERROR.TYPE
XERROR.TYPE displays the XTYPE-style error type or error name for all Excel errors
0
Votes
XERROR
XERROR allows for conveniently generating most of the Excel errors as output to functions
0
Votes
TOFILE
TOFILE, a function putting a delmiter between the headers and each cell with regards to hiding columns.
0
Votes
FSPL
FSPL calculates the 'Free Space Path Loss' for a given frequency, distance, transmitter gain, and receiver gain.
0
Votes
UNPIVOT
Translates a set of columns in a table into attribute-value pairs, combined with the rest of the values in each row
0
Votes
TEXTSPLITVAR
Return one variable from a string with items separated by a delimiter of one or more characters
0
Votes
CELLWIDTH
Function to return ONLY the Width of the Optional referenced cell.
0
Votes
UNPIVOTHEADERS
UNPIVOTHEADERS function replicates the Power Query function "unpivot other columns", from the first column, where row labels expand out with their column values.
