View Single Post
  #4   Report Post  
Biff
 
Posts: n/a
Default Need help with arrays (I think)

Hi!

In your original post you say:

C4 that starts at 1 and then in cell C5 is 2, then 3 ....


That "sounds" like a column to me!

If you want it across a ROW:

=IF(ISERR($A2/$B2),"",IF(COLUMNS($C4:C4)<=$A2/$B2,COLUMNS($C4:C4),""))

Copy ACROSS as needed.

Biff

"rbhedal" wrote in
message ...

Biff,
I tried your suggestion & it kind of worked but, instead of getting
c4=1, d4=2, etc... All I got was c4=1 & then it stoped. Any sugestions
on how to fix that?


--
rbhedal
------------------------------------------------------------------------
rbhedal's Profile:
http://www.excelforum.com/member.php...o&userid=28199
View this thread: http://www.excelforum.com/showthread...hreadid=477404