auto renumbering rows with blank spaces

  • Thread starter Thread starter edithprado
  • Start date Start date
E

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!
 
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))
 
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
 
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!
 
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!
 
None of these seem to work, I'll just keep doing what I was doing. Thanks
all, I appreciate it!
 
Back
Top