Welcome! and rules Joel on Software |
Excel Array Formula using C# I'm trying to write a series of formulas which we can use in Excel reports to grab some data from our database so I wrote a function in c# which could be used in an array like so:
Marcus
fixed now. if anyone cares, the solution is that array formulas in Excel are 2 dimensional arrays and the 1st dimension is horizontal and the 1st is vertical. Hence to make an array formula which fills vertically down (which is what I was trying to do) you need to return and array of
Marcus
Fog Creek Home |