Array
 

I have an array-formula called DateRate() that return a list of dates and
their rates for example DateRate(Ben) will return:
10/02/2006 20
15/02/2006 34
17/02/2006 56
03/10/2006 40

I will need to have a function that is not an array formula and that will
return only the rate of the first date. For example in this case 20.

Is it doable?

Many thanks
Paul

Array
 

You want another function that will return the value 20?

it should be doable.

Without knowing mo

Public Function Rate1(Ben)
v = DateRate(ben)
Rate1 = v(lbound(v,1), lbound(v,2)+1)
End Function

--
Regards,
Tom Ogilvy


"guedj54" wrote in message
...
I have an array-formula called DateRate() that return a list of dates and
their rates for example DateRate(Ben) will return:
10/02/2006 20
15/02/2006 34
17/02/2006 56
03/10/2006 40

I will need to have a function that is not an array formula and that will
return only the rate of the first date. For example in this case 20.

Is it doable?

Many thanks
Paul

Array
 

Many Thanks Tom.

"Tom Ogilvy" wrote:

You want another function that will return the value 20?

it should be doable.

Without knowing mo

Public Function Rate1(Ben)
v = DateRate(ben)
Rate1 = v(lbound(v,1), lbound(v,2)+1)
End Function

--
Regards,
Tom Ogilvy


"guedj54" wrote in message
...
I have an array-formula called DateRate() that return a list of dates and
their rates for example DateRate(Ben) will return:
10/02/2006 20
15/02/2006 34
17/02/2006 56
03/10/2006 40

I will need to have a function that is not an array formula and that will
return only the rate of the first date. For example in this case 20.

Is it doable?

Many thanks
Paul