A couple of questions ...
1. Is there a maximum number of sections that you're expecting?
2. Is it OK to designate an "Answer Table Area" equal in size to the
maximum number of sections?
3. What do you want to do with any remainders from the division
calculation (eg 22/5 = 4 with 2/5 over)?
Rgds,
ScottO

"Robert" <Robert @discussions.microsoft.com 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