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!

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!

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!

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!

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!

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!