LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default I need help with arrays (Still)


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
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Arrays Brendan Vassallo Excel Discussion (Misc queries) 4 February 23rd 06 02:27 AM
Arrays Tobro88 Excel Discussion (Misc queries) 3 November 18th 05 11:28 PM
Arrays Dani Excel Programming 1 June 7th 05 05:28 PM
VBA arrays hokiebird Excel Programming 3 November 11th 04 10:38 AM
Help with arrays please Gary[_18_] Excel Programming 6 June 27th 04 08:29 PM


All times are GMT +1. The time now is 02:54 AM.

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

About Us

"It's about Microsoft Excel"