Excel 2007 : counting rows

**rossmoyne** · 02-03-2011, 05:44 PM

how do I do a running count of rows. I have a list of 12000+ items that I would like to number, but as I go through them, I will be deleting about half, but I want the count to update as I delete them.

Thanks.

**shg** · 02-03-2011, 06:06 PM

Welcome to the forum.

If column A is available, and row 1 is the header, then in A2 and copy down

=ROWS(A$1:A2)-1

**rossmoyne** · 02-04-2011, 10:56 AM

Thanks, but that does add up the total rows I have, but that's not what I need. Let me rephase my question:

I want each row to have a unique number. I can do that easy enough at the start, by putting an '1 in the first cell / row I want counted and then dragging it down. However, doing it that way, if I delete row 4, then my overall count doesn't update, row 5 is still row 5, when now it should be the new row 4.

What I would like, is a way for the row numbers to update automatically when delete a row, instead of having to manually redo the row numbers.

Any help would be greatly appreciated.

Thanks.

**jwright650** · 02-04-2011, 11:04 AM

Originally Posted by runnymede15june1215

Thanks, but that does add up the total rows I have, but that's not what I need. Let me rephase my question:

I want each row to have a unique number.

His formula does exactly what you asked...try it, see example attached

Deleted a few rows out of this example...they automatically renumber themselves

**rossmoyne** · 02-04-2011, 12:43 PM

Your right. I must have done something wrong the first time.

**jwright650** · 02-04-2011, 01:31 PM

If you're satisfied with his solution click on the scales in his post and give him some credit, then go back and edit your first post in this thread to "solved.

....to mark thread as solved, choose edit button, then choose Go Advanced, scroll up to the title and change the prefix to Solved, and then choose save.