Need help with arrays (I think)

[rbhedal]

I have a slight problem that Excel either can not do or I can not enter the formula
correctly. I am asking for your expertise. What I need is to enter Value A
into a cell and then enter Value B into a cell, have Excel do the division,
and then generate a table with that number of rows. For example, if I enter
"20" into cell A2, enter "5" into cell B2, I need Excel to generate a table
in cell C4 that starts at 1 and then in cell C5 is 2, then 3 ....

Can anyone give me some assistance with this. It would be greatly appreciated.

[Biff]

Hi!

Try this:

What happens if A2 = 20 and B2 = 3?

Enter this formula in C4 and copy down as far as you think you'll need:

=IF(ISERR(A$2/B$2),"",IF(ROWS(C$4:C4)<=A$2/B$2,ROWS(C$4:C4),""))

Biff

"rbhedal" <[email protected]> wrote in
message news:[email protected]...
>
> I have a slight problem that Excel either can not do or I can not enter
> the formula
> correctly. I am asking for your expertise. What I need is to enter
> Value A
> into a cell and then enter Value B into a cell, have Excel do the
> division,
> and then generate a table with that number of rows. For example, if I
> enter
> "20" into cell A2, enter "5" into cell B2, I need Excel to generate a
> table
> in cell C4 that starts at 1 and then in cell C5 is 2, then 3 ....
>
> Can anyone give me some assistance with this. It would be greatly
> appreciated.
>
>
> --
> rbhedal
> ------------------------------------------------------------------------
> rbhedal's Profile:
> http://www.excelforum.com/member.php...o&userid=28199
> View this thread: http://www.excelforum.com/showthread...hreadid=477404
>

[rbhedal]

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?

[Biff]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>