I turned my giant Excel formula into something I can actually understand

We all know someone who loves building a ridiculously complicated Excel formula and proudly announcing that it works. I used to be that person. I’ve been writing Excel formulas for decades, and I loved the satisfaction of making a single formula handle a problem that once seemed impossible. The trouble was, those formulas could become a lot less impressive when I came back to them later. Then along came the LET function.