Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help with arrays (I think)
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 C5 is 2, then 3 .... Can anyone give me some assistance with this. It would be greatly appreciated. -- rbhedal ------------------------------------------------------------------------ rbhedal's Profile: http://www.excelforum.com/member.php...o&userid=28199 View this thread: http://www.excelforum.com/showthread...hreadid=477404 |
#2
|
|||
|
|||
Need help with arrays (I think)
Hi!
Try this: What happens if A2 = 20 and B2 = 3? Enter this formula in C4 and copy down as far as you think you'll need: =IF(ISERR(A$2/B$2),"",IF(ROWS(C$4:C4)<=A$2/B$2,ROWS(C$4:C4),"")) Biff "rbhedal" 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 C5 is 2, then 3 .... Can anyone give me some assistance with this. It would be greatly appreciated. -- rbhedal ------------------------------------------------------------------------ rbhedal's Profile: http://www.excelforum.com/member.php...o&userid=28199 View this thread: http://www.excelforum.com/showthread...hreadid=477404 |
#3
|
|||
|
|||
Need help with arrays (I think)
Biff, I tried your suggestion & it kind of worked but, instead of getting c4=1, d4=2, etc... All I got was c4=1 & then it stoped. Any sugestions on how to fix that? -- rbhedal ------------------------------------------------------------------------ rbhedal's Profile: http://www.excelforum.com/member.php...o&userid=28199 View this thread: http://www.excelforum.com/showthread...hreadid=477404 |
#4
|
|||
|
|||
Need help with arrays (I think)
Hi!
In your original post you say: C4 that starts at 1 and then in cell C5 is 2, then 3 .... That "sounds" like a column to me! If you want it across a ROW: =IF(ISERR($A2/$B2),"",IF(COLUMNS($C4:C4)<=$A2/$B2,COLUMNS($C4:C4),"")) Copy ACROSS as needed. Biff "rbhedal" wrote in message ... Biff, I tried your suggestion & it kind of worked but, instead of getting c4=1, d4=2, etc... All I got was c4=1 & then it stoped. Any sugestions on how to fix that? -- rbhedal ------------------------------------------------------------------------ rbhedal's Profile: http://www.excelforum.com/member.php...o&userid=28199 View this thread: http://www.excelforum.com/showthread...hreadid=477404 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3D Arrays | Excel Worksheet Functions | |||
Problem with plotting a chart when using arrays as Values and Xvalues | Charts and Charting in Excel | |||
Confused about arrays and ranges in functions | Excel Worksheet Functions | |||
Comparing Arrays | Excel Discussion (Misc queries) | |||
Comparing Arrays | Excel Worksheet Functions |