Named Range Operations

[jtrowbridge]

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:

[jtrowbridge]

That post didnt look very clean. to clarify =VALUE() is the name of my hypothetical function. I could have called it =CUSTOMFUNCTION(a,b,c) to be more clear.

Second, here's a cleaner table for the named range's contents:

11/1/2008 5.859
12/1/2008 6.298
1/1/2009 6.510
2/1/2009 6.604
3/1/2009 6.501
4/1/2009 6.319