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
FLIP
FLIP is a powerful range/array flipping solution with full control over data type(s) inclusion/exclusion in the output
Replies
1
Views
446
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'
Replies
4
Views
800
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
Replies
2
Views
853
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",)
Replies
3
Views
1K
0 Votes
ISINT
ISINT allows for checking if the reference contains integer value(s) and provides logical output
Replies
1
Views
439
0 Votes
XERROR.TYPE
XERROR.TYPE displays the XTYPE-style error type or error name for all Excel errors
Replies
1
Views
372
0 Votes
XERROR
XERROR allows for conveniently generating most of the Excel errors as output to functions
Replies
1
Views
691
1 Vote
SCANBYROW
Performs a SCAN(initial_value,row,fn) on each row of array.
Replies
5
Views
2K
0 Votes
TOFILE
TOFILE, a function putting a delmiter between the headers and each cell with regards to hiding columns.
Replies
18
Views
1K
0 Votes
APALINDROME
checks an array for palindromes
Replies
9
Views
882
0 Votes
FSPL
FSPL calculates the 'Free Space Path Loss' for a given frequency, distance, transmitter gain, and receiver gain.
Replies
0
Views
1K
0 Votes
FMPL
FMPL calculates the 'First Meter Path Loss' for radio frequencies.
Replies
0
Views
269
0 Votes
DBM2WATT
Convert a value from dbm to watts
Replies
0
Views
2K
0 Votes
WATT2DBM
Convert watts to dbm
Replies
0
Views
500
1 Vote
FREQCONV
Convert a frequency e.g. mhz to ghz
Replies
0
Views
301
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
Replies
2
Views
1K
0 Votes
XTRACT
Extract either letters or numbers from a given string
Replies
0
Views
424
0 Votes
TEXTSPLITVAR
Return one variable from a string with items separated by a delimiter of one or more characters
Replies
1
Views
419
0 Votes
CELLWIDTH
Function to return ONLY the Width of the Optional referenced cell.
Replies
7
Views
676
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.
Replies
2
Views
585

Forum statistics

Threads
1,216,499
Messages
6,131,012
Members
449,613
Latest member
MedDash99

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