I use Excel LAMBDA and LET *all* the time. They are incredibly powerful, particularly when combined with each other and with Excel's other functions that use LAMBDA as a helper (eg MAP and REDUCE) and with arrays more broadly, particularly using TRIMRANGE/trimrefs.

Use Excel's new TRIMRANGE function and Trim References to remove leading and trailing blank rows and columns from a data range.

youtu.be/ufGJjtsXRZs

#ms365 #msoffice #office #excel #trimrange #trimrefs