Prev: conditional formatting
Next: Variable Range in Formula
From: clacount on 12 May 2010 12:36
If I put numbers in Column A (1, 2, 3 etc.) and then I will have to remove
various rows from Column A (#10, #15, #34, #45 etc.) can I get Column A to
automatically renumber in sequence after I remove variuos rows?
--
clacount
From: Jim Thomlinson on 12 May 2010 12:45
You can use the Row() function to deteremine the row that the formula is in.
Using an offset such as
=row() + 3
will allow you to get the numbering you want. Note however that row() is a
volatile function and if you have thoushads of these functions you could
adversely affect performance.
--
HTH...

Jim Thomlinson


"clacount" wrote:

> If I put numbers in Column A (1, 2, 3 etc.) and then I will have to remove
> various rows from Column A (#10, #15, #34, #45 etc.) can I get Column A to
> automatically renumber in sequence after I remove variuos rows?
> --
> clacount
From: Gary''s Student on 12 May 2010 12:46
In Aa1, enter:

=ROW() and copy down
--
Gary''s Student - gsnu201002


"clacount" wrote:

> If I put numbers in Column A (1, 2, 3 etc.) and then I will have to remove
> various rows from Column A (#10, #15, #34, #45 etc.) can I get Column A to
> automatically renumber in sequence after I remove variuos rows?
> --
> clacount
From: dlw on 12 May 2010 12:49
put a 1 in A1, then highlight A1 and the rest you want to renumber, then Edit
> Fill > series > OK

"clacount" wrote:

> If I put numbers in Column A (1, 2, 3 etc.) and then I will have to remove
> various rows from Column A (#10, #15, #34, #45 etc.) can I get Column A to
> automatically renumber in sequence after I remove variuos rows?
> --
> clacount
 | 
Pages: 1
Prev: conditional formatting
Next: Variable Range in Formula