I want more!

[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

 

[Dave Peterson]

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)

 

[JB]

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

 

[Dave Peterson]

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?

 

[JB]

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