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