Macros are powerful, but they don't work on the web or mobile. I’ve switched to the native REDUCE function for my complex ...

For years, I solved complex spreadsheet problems the same way: adding helper columns, stacking increasingly nested formulas, and, when things became especially tangled, resorting to Excel’s VBA macros ...