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 ...

Working with large spreadsheets means constantly tracking rows and columns, and it's easy to lose your place when you're staring at hundreds of cells. I've tried different workarounds over the years — ...