I know how to write Excel formulas, but I just don't need to. Memorizing argument order for XLOOKUP or counting parentheses in a nested IF has never been the interesting part of working with data.

Excel is deceptively powerful. Just when I think I’ve mastered it, it pulls another trick out of nowhere. This latest feature has me wondering how much time I’ve wasted not using it sooner. I was at a ...