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