auto renumbering rows with blank spaces
 

I am so stumped on this one simple function! I am compiling an inventory list
of key rings we loaned to employees. Since there are different departments
with a varying amount of employees each, I skip a line between departments .

The problem: there are 700+ employees so far and since I skip a line,
renumbering if off, so I have to highlight each department and use the ROW()
function to maintain the proper numbering sequence. I am sure that there is a
function that allows for automatic renumbering, or automatic updating for the
column whenever a row is deleted, added, etc. I just don't remember where to
go to turn that on. Help!

auto renumbering rows with blank spaces
 

Try this...

Numbering will appear in column A based on entries in column B.

Enter this formula in A1 and copy down as needed:

=IF(B1="","",COUNTA(B$1:B1))

--
Biff
Microsoft Excel MVP


"edithprado" wrote in message
...
I am so stumped on this one simple function! I am compiling an inventory
list
of key rings we loaned to employees. Since there are different departments
with a varying amount of employees each, I skip a line between departments
.

The problem: there are 700+ employees so far and since I skip a line,
renumbering if off, so I have to highlight each department and use the
ROW()
function to maintain the proper numbering sequence. I am sure that there
is a
function that allows for automatic renumbering, or automatic updating for
the
column whenever a row is deleted, added, etc. I just don't remember where
to
go to turn that on. Help!

auto renumbering rows with blank spaces
 

Put in A2 the following formula and copy down worksheet. Yo ucan't put it in
row 1 because you can't reference row 0

=COUNTA(A$1:A1)+1

"edithprado" wrote:

I am so stumped on this one simple function! I am compiling an inventory list
of key rings we loaned to employees. Since there are different departments
with a varying amount of employees each, I skip a line between departments .

The problem: there are 700+ employees so far and since I skip a line,
renumbering if off, so I have to highlight each department and use the ROW()
function to maintain the proper numbering sequence. I am sure that there is a
function that allows for automatic renumbering, or automatic updating for the
column whenever a row is deleted, added, etc. I just don't remember where to
go to turn that on. Help!

auto renumbering rows with blank spaces
 

Hm, that doesn't really help. Maybe I should've better stated what I was
saying. I want the rows to automatically renumber when I delete/add a row and
that formula does not do so. Also, I meant that I skip 2 lines before the
numbering continues, one is a blank space and one does not "count" since it
is a row that lists the name of the department. Thank you for your help
though!

"T. Valko" wrote:

Try this...

Numbering will appear in column A based on entries in column B.

Enter this formula in A1 and copy down as needed:

=IF(B1="","",COUNTA(B$1:B1))

--
Biff
Microsoft Excel MVP


"edithprado" wrote in message
...
I am so stumped on this one simple function! I am compiling an inventory
list
of key rings we loaned to employees. Since there are different departments
with a varying amount of employees each, I skip a line between departments
.

The problem: there are 700+ employees so far and since I skip a line,
renumbering if off, so I have to highlight each department and use the
ROW()
function to maintain the proper numbering sequence. I am sure that there
is a
function that allows for automatic renumbering, or automatic updating for
the
column whenever a row is deleted, added, etc. I just don't remember where
to
go to turn that on. Help!

auto renumbering rows with blank spaces
 

Hmmm...

I'm pretty sure what I suggested will do what you want.

If you delete a row the numbers will reorder. If you "add" rows by inserting
them *within* the current range then you'll need an event macro to do this.
I'm probably not the person to suggest how to do that, though!

--
Biff
Microsoft Excel MVP


"edithprado" wrote in message
...
Hm, that doesn't really help. Maybe I should've better stated what I was
saying. I want the rows to automatically renumber when I delete/add a row
and
that formula does not do so. Also, I meant that I skip 2 lines before the
numbering continues, one is a blank space and one does not "count" since
it
is a row that lists the name of the department. Thank you for your help
though!

"T. Valko" wrote:

Try this...

Numbering will appear in column A based on entries in column B.

Enter this formula in A1 and copy down as needed:

=IF(B1="","",COUNTA(B$1:B1))

--
Biff
Microsoft Excel MVP


"edithprado" wrote in message
...
I am so stumped on this one simple function! I am compiling an inventory
list
of key rings we loaned to employees. Since there are different
departments
with a varying amount of employees each, I skip a line between
departments
.

The problem: there are 700+ employees so far and since I skip a line,
renumbering if off, so I have to highlight each department and use the
ROW()
function to maintain the proper numbering sequence. I am sure that
there
is a
function that allows for automatic renumbering, or automatic updating
for
the
column whenever a row is deleted, added, etc. I just don't remember
where
to
go to turn that on. Help!

auto renumbering rows with blank spaces
 

None of these seem to work, I'll just keep doing what I was doing. Thanks
all, I appreciate it!

"Joel" wrote:

Put in A2 the following formula and copy down worksheet. Yo ucan't put it in
row 1 because you can't reference row 0

=COUNTA(A$1:A1)+1

"edithprado" wrote:

I am so stumped on this one simple function! I am compiling an inventory list
of key rings we loaned to employees. Since there are different departments
with a varying amount of employees each, I skip a line between departments .

The problem: there are 700+ employees so far and since I skip a line,
renumbering if off, so I have to highlight each department and use the ROW()
function to maintain the proper numbering sequence. I am sure that there is a
function that allows for automatic renumbering, or automatic updating for the
column whenever a row is deleted, added, etc. I just don't remember where to
go to turn that on. Help!