[KLUG Members] calc

[komal]

Thank you for your answer. Yes i want "ascending sequence" .how to perform
that?
komal
----- Original Message -----
From: "Adam Tauno Williams" <adam@morrison.iserv.net>
To: <members@kalamazoolinux.org>
Sent: Tuesday, November 18, 2003 10:59 AM
Subject: Re: [KLUG Members] calc


> > No. I think you didn't get me correctly. I want to design sheet in a
such a
> > way that if i enter number in A5 to A50 like 1 to 50 and if i delete any
one
> > of the row say A35 then all the number in a a5 to a50 should
automatically
> > update.
>
> You want a "row count" or an "ascending sequence"?
>
> Row Count;  All cells = the same value,  the number of rows included in
the
> range.  Delete a row and all cell decriment by 1.
>
> Ascending sequcne; If A5 = 1, then A6 = 2, then At = 3.  Delete a row
anywhere
> between 5 & 50 and all rows below that row decrement by one.
> _______________________________________________
> Members mailing list
> Members@kalamazoolinux.org
>