How do I number rows automatically?

  • Thread starter Thread starter aeggers
  • Start date Start date
A

aeggers

I want to add an automatic (ie self-changing) numbering column to
worksheet. I would like the left most column to have anumer if th
next column to the right has text, and then add 1 number to that colum
for each subsequent row. An eg:
1. Joe Blow 123 Main st
2. Sara Silver, 221 Green Ave
3. Fred Red, 444 Bloacl Blvd.
where if I add text to the next 1st name column, the next number i
automatically fillled or if I delete the row with Sara Silver, then th
next ro read:
2. Fred Red etc
I have tried using the formulas and the help, but to no avail.
Thanks for your assistance.
A
 
Hi

try the following in A1:
=IF(B1="","",ROW())
and copy this down the entire column

Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

compare columns and rows 4
Calculate total by row number 4
serial number needs to change automatically 4
automatic population of rows 1
Adding/Removing Rows Automatically. 1
lookup row number 3
Automatically put rows containing a number in numerical order 1
Auto update row numbers after inserting new row 4

Back
Top