Auto numbering in corresponding row

Aussie Grid

New Member
Joined
Jan 14, 2010
Messages
47
I need to have the corresponding row numbers auto update in column A, if it is blank, whenever new data is added.
i.e. If there is no row number in A7 when I enter data in D7 then auto enter the row number into the corresponding row in col A, A7 in this case. Obviously do nothing if there is a number in corresponding row A8 if cell G8 is selected etc.
I also need the numbers in A to auto update when a row is added or deleted.
Possible?
Any and all assistance appreciated.
Aussie Grid
 
Sorry superbeast 326 but I need the auto numbers in col A to auto populate, if it is blank, when data is entered anywhere, not just a specific cell.
Thanks
Aussie Grid
 
Upvote 0
Try;

=IF(COUNTIF(B1:Z1,"<>"),ROW(),"")

Assumes entry range within B through Z. Change this reference as required.
 
Upvote 0
Thank you Jon that is almost perfect. The only draw back is when a new row is added, the formula isn't in col A so there is no number.
Any ideas?
Thanks again
Aussie Grid
 
Upvote 0

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
Back
Top