auto renumbering rows with blank spaces

[edithprado]

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!

 

[T. Valko]

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))

 

[Joel]

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]

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]

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!

 

[edithprado]

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