News for hackers. Stuff that matters.
Re:Visualise the structure of a spreadsheet by thegranderson on Thursday October 24, 2013 @05:49PM (#6608236)
While Excel has SOME debugging features, they really don't work well at ALL for large formulas. I don't need something to help me debug some multiplication.

But when I'm offsetting to an array upon which I'm selecting and summing a subset of these cells with an if-driven sumproduct, and maybe dynamically looking up all of the ranges with more index/matches.... its impossible to look at in the little formula tracing box.

I can't wait to try this out.

There are no comments on this comment yet.