LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Robert
 
Posts: n/a
Default I need Help!


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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"