Sumproduct to Table...

[DonkeyOte]

Does anyone know of a utility / function or have themselves coded something that permits an end user to analyse a given Sumproduct formula in greater detail - ie returning the results of the generated array into tabular form ?

I've just sat down thinking this would be quite useful, ie I click on any sumproduct formula and run a routine to "Analyse" which in turn generates a new sheet with a matrix of the results...

However having just started coding this myself it is now dawning on me that this could prove very difficult (read beyond my abilities) ... breaking out the formula itself etc into component parts is pretty easy but actually evaluating each part is a little more difficult.

I suspect someone knows of an elegant way to do this and I'd love to see it... it may of course be that you can do this already but I don't know how...

Thanks,
Luke

 

[cornflakegirl]

I got a floating toolbar - was that intentional?

All worked fine. Although I was rather amused that you protected the code

 

[DonkeyOte]

Yes...

and I know
(password is related to pre-sanctuary)

Edit: I'll probably add as a right click like the DRILL add-in which was posted up a while back... which I investigated earlier to see how it would handle the Sumproducts (given it finds precedents) -- couldn't handle the more complex formulae unfortunately...