If at all possible I'd like to do this without VBA, and I'd like it to work cross-platform in Win Office as well as Mac Office. My cumbersome method currently does both, but it's . . . cumbersome. If ...

Have you ever found yourself tangled in a web of complex Excel formulas, trying to make sense of sprawling datasets with traditional functions like SUMIFS? Many of us have been there, struggling with ...