Ineed help with arrays (I think)
 

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 D4 is 2, then 3 ....

If further elaboration is needed, what I am looking for is this. If I have a
distance of say 20 meters & I want to break it into 5 equal sections. I will
enter 20 in cell A2 and enter 5 in cell A3. I want Excel to realize (from my
input of 5) that I want 5 columns. Say I enter the "code" in cell C5 I want
Excel to place a "1" in cell C5, & in cell D5, place a "2", in D6, place a
"3"... until it reaches the nmber of sections that I asked for. I hope this
is clear & I hope that someone can help.

Thank you

Ineed help with arrays (I think)
 

See reply in .newusers

Biff

"Robert" wrote in message
...
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 D4 is 2, then 3 ....

If further elaboration is needed, what I am looking for is this. If I have
a
distance of say 20 meters & I want to break it into 5 equal sections. I
will
enter 20 in cell A2 and enter 5 in cell A3. I want Excel to realize (from
my
input of 5) that I want 5 columns. Say I enter the "code" in cell C5 I
want
Excel to place a "1" in cell C5, & in cell D5, place a "2", in D6, place a
"3"... until it reaches the nmber of sections that I asked for. I hope
this
is clear & I hope that someone can help.

Thank you

Ineed help with arrays (I think)
 

Hi Robert,

See responses to each post in programming

---
Regards,
Norman



"Robert" wrote in message
...
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 D4 is 2, then 3 ....

If further elaboration is needed, what I am looking for is this. If I have
a
distance of say 20 meters & I want to break it into 5 equal sections. I
will
enter 20 in cell A2 and enter 5 in cell A3. I want Excel to realize (from
my
input of 5) that I want 5 columns. Say I enter the "code" in cell C5 I
want
Excel to place a "1" in cell C5, & in cell D5, place a "2", in D6, place a
"3"... until it reaches the nmber of sections that I asked for. I hope
this
is clear & I hope that someone can help.

Thank you