Re: Defining range using cell value

On Sat, 2006-24-06 at 21:22 +0200, Berthold Höllmann wrote:
I have a spreadsheet where I regular add lines with 14 columns. From
some of these columns I calculate SLOPE, INTERCEPT, or FORECAST. These
functions do not work using ranges as $A:$A that I can use in graphs.
These ranges are accepted, but the calculated values are wrong. I
tried using ADDRESS, but without sucess. 

perhaps something like
where A1 contains the number of rows can help you too.



Prof. Dr. Andreas J. Guelzow
Dept. of Mathematical & Computing Sciences
Concordia University College of Alberta

Attachment: signature.asc
Description: This is a digitally signed message part

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]