Insert numbers when column A is blank

planetpj

Active Member
Joined
Jun 25, 2002
Messages
347
What I am looking to do is get a formula that automatically places numbers in Column A if the cell is blank. Once column A has something in it the numbering stops and when it is blank again start the numbering process starts again from 1.
Book1
ABCD
1Barnum
21
32
43
5Beardsley
61
72
83
9Blackham
101
112
123
13BlackRock
141
152
163
17Bryant
181
192
203
21Columbus
221
232
243
Sheet1
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

planetpj

Active Member
Joined
Jun 25, 2002
Messages
347
Juan you got it right on the ball. Buy the way a very interesting answer!! I was trying to go about it differently but you learn something new everyday!!! Thank you again and God Bless!!
 

Forum statistics

Threads
1,144,050
Messages
5,722,234
Members
422,417
Latest member
Johhny

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top