R
rbhedal
I have a slight problem that Excel either can not do or I can not ente
the formula correctly. I am asking for your expertise. What I need i
to enter Value A into a cell and then enter Value B into a cell, hav
Excel do the division, and then generate a table with that number o
rows. For example, if I enter "20" into cell A2, enter "5" into cel
B2, I need Excel to generate a table in cell C5 that starts at 1 an
then in cell D5 is 2, then 3 in cell E5, etc....
The number that I enter for the prompt "sections" is the number o
columns that I need Excel to generate. I need Excel to do thi
automatically (preferably without the user having to "click and drag
anything. I have included an example output of what I need th
spreadsheet to look like to, hopefully, help explain my idea. It is se
up just like a spreadsheet; where the letters represent the columns
the numbers (on the left) represent the rows.
A B C D E
F G
1:
2: distance 20
3: sections 5
4:
5: 1 2 3 4 5
6:
If you can help, please explain in as basic of terms as possible.
Thank yo
the formula correctly. I am asking for your expertise. What I need i
to enter Value A into a cell and then enter Value B into a cell, hav
Excel do the division, and then generate a table with that number o
rows. For example, if I enter "20" into cell A2, enter "5" into cel
B2, I need Excel to generate a table in cell C5 that starts at 1 an
then in cell D5 is 2, then 3 in cell E5, etc....
The number that I enter for the prompt "sections" is the number o
columns that I need Excel to generate. I need Excel to do thi
automatically (preferably without the user having to "click and drag
anything. I have included an example output of what I need th
spreadsheet to look like to, hopefully, help explain my idea. It is se
up just like a spreadsheet; where the letters represent the columns
the numbers (on the left) represent the rows.
A B C D E
F G
1:
2: distance 20
3: sections 5
4:
5: 1 2 3 4 5
6:
If you can help, please explain in as basic of terms as possible.
Thank yo