I want more!

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

I need to extend a form that aleady has some 100 lines. For instance, one
column has the date, but only until tomorroq. How do I create more lines
based on the same formula?

Thank you

JB
 
I usually select the last row in the range and copy it down a few rows.

If you're using xl2003, you may want to look at Data|List.

And if you're using xl2007, this feature has transformed into Tables.
(Data tab on the ribbon|Data tools Group|What if Analysis|Data table)
 
Thank you

It worked, except for columns where I average, like:

=IF(I4:K4>0,AVERAGE(I4:K4),"")

What should I do with those?

Thank you again

JB
 
First, I would have thought that you'd want a formula like:
=IF(count(I4:K4)>0,AVERAGE(I4:K4),"")
(check for at least one number before trying to get the average.)

Second, what did you use?

And how did it not work?
 
Thanks

The formula has been working for some time. Someone helped me in this forum
before.

Basically, I take 4 readings a day of my blood sugar and the formula is
supposed to average them.

When I try to extend this partcular column downwards, by copying the last
cell and pasting it after dragging donwards, it tells me
'You cannot change part of an array'

JB
 
Back
Top