View Single Post
  #1   Report Post  
Dongle
 
Posts: n/a
Default Filling an array with data

Using Excel 2003. Trying to fill an amount of cells with data. The amount is
depending on an other cell. Example:
A1 = 6, B1 = 3.81.
A2 =3, B2 = 6.53
Now I want C1:C6 to be 3.81 and C7:C9 to be 6.53 and when A1 = 9, I want
C1:C9 to be 3.81
Thanks in advance for any help.
Dongle