#let function

Excel’s LET function is a powerful tool for improving formula readability and performance by allowing you to assign names to calculations or expressions. We will explore the LET function, step-by-step, and explain how it works with a practical example. What is the LET Function? The LET function simplifies complex formulas by enabling you to: Define and reuse variables within a…

Dynamic Array Histogram Dynamic Arrays make it easier than ever to generate a data range for a histogram, including a normal curve overlay. LET and LAMBDA functions make it even easier and more flexible.

My friend Thom and I had a discussion about tracking weight and using histograms to show the shape of the weight distribution. He told me he disliked the native Excel Histograms, and I agreed. I’ve written a lot of articles about histograms (see the list at the end of this article), and my commercial software, Peltier Tech Charts for Excel, provides a couple types of histogram which are much more…

VBA Test for New Excel Functions: Excel has awesome new Dynamic Array, LET, and LAMBDA functions. Here's a VBA test for whether a user's installation supports these functions.

I’ve written several articles and done a few presentations about the new functions in Excel, such as Dynamic Arrays, the LET function, and the latest, the LAMBDA function. As I continue to build VBA-based workbooks and add-ins, I realize how much easier these features make the projects I’m working on, and I am planning to release Microsoft 365 versions of these projects. Someone recently asked…

Dynamic Arrays, XLOOKUP, LET – New Excel Features

Office 365 keeps bringing us new stuff

Last week, I wrote my first blog post in a few months. I wrote about Watching my Weight with SPC (Statistical Process Control).

In the first comment, Derek asked for a box plot, so I quickly recompiled my data and built one.

Several new features of Office 365 made it very easy to mush my data around, and I realized that this is a good example to…

FileMaker Let Function and Text Manipulation

FileMaker Let Function and Text Manipulation I recently encountered the following challenge:  There were just shy of two thousand web based photo files linked in a FileMaker database, and these files were of multiple types (jpegs, jpg’s, png, and tiffs) of all different sizes – high resolution, medium resolution, different heights and widths. Most of these files were already linked to two…

FileMaker Function of the Week: The Let Function

THE LET FUNCTION is the main function that allows you to write functions similar to php and other languages.  You can declare variables on the fly that only exist while the function is evaluating, and not have to clean them up afterward.  You can manipulate data to the nth degree and return a result (or not) that you can pass on.  FullCity goes into more detail and ties it back to their example…