Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 C4 that starts at 1 an then in cell D4 is 2, then 3 .... If further elaboration is needed, what I am looking for is this. If have a distance of say 20 meters & I want to break it into 5 equa sections. I will enter 20 in cell A2 and enter 5 in cell A3. I wan Excel to realize (from my input of 5) that I want 5 columns. Say 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 th nmber of sections that I asked for. I hope this is clear & I hope tha someone can help. If you can help, please explain in as basic of terms as possible. Thank yo -- rbheda ----------------------------------------------------------------------- rbhedal's Profile: http://www.excelforum.com/member.php...fo&userid=2819 View this thread: http://www.excelforum.com/showthread.php?threadid=47778 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Arrays | Excel Discussion (Misc queries) | |||
Arrays | Excel Discussion (Misc queries) | |||
Arrays | Excel Programming | |||
VBA arrays | Excel Programming | |||
Help with arrays please | Excel Programming |