Another thread "Probably another stupid calc question", about statistics
using cells with text or null values prompts this question.
How do I specify that I want to use the *value* in a cell as part of a
row or column reference. Suppose I have the value 23 in cell B1. I want
to refer to the data in A1:A23 but I don't "know" that it's 23 this time
around. I want to say from A1 down to and including A<contents_of_B1>
and have "<contents_of_B1> interpreted as 23 this time but as whatever
is in B1 next time. Altering the value of B1 should explicitly alter the
range of cells being referenced. Is this possible in Calc? How?
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
