Thread: Array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
guedj54 guedj54 is offline
external usenet poster
 
Posts: 7
Default 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