jtrowbridge
10-22-2008, 03:05 PM
Hey all, got a quick question about named ranges in Excel. I'm using a function to compute some values and I'm feeding a (2 x n) array into the function through a named range. I have an equation in a cell that goes something like this:
=VALUE(2xnNamedrange, parameter1, parameter2)
Here's the contents of the named range:
11/1/20085.85912/1/20086.2981/1/20096.5102/1/20096.6043/1/20096.5014/1/20096.319
Now here's where I'm stuck. I'd like to invert the data in the second column through the function call. This would get me something like this:
=VALUE(1/(2xnNamedrange), parameter1, parameter2)
I run into trouble when I invert the array becuase I'm inverting the date values (left column) along with the decimal values (right column).
I understand that I can create a second array with inverted values but I would like to use only one named range.
The last constraint on this issue is that I'm using a proprietary (encrypted) function which means I can't break into the function code and create a VB solution by modifying the source code of the function.
Anyone got any ideas?
:think:
=VALUE(2xnNamedrange, parameter1, parameter2)
Here's the contents of the named range:
11/1/20085.85912/1/20086.2981/1/20096.5102/1/20096.6043/1/20096.5014/1/20096.319
Now here's where I'm stuck. I'd like to invert the data in the second column through the function call. This would get me something like this:
=VALUE(1/(2xnNamedrange), parameter1, parameter2)
I run into trouble when I invert the array becuase I'm inverting the date values (left column) along with the decimal values (right column).
I understand that I can create a second array with inverted values but I would like to use only one named range.
The last constraint on this issue is that I'm using a proprietary (encrypted) function which means I can't break into the function code and create a VB solution by modifying the source code of the function.
Anyone got any ideas?
:think: