Learn Excel 2010 (Automatic List Numbering with Empty Rows)

We can use auto fill option for automatic serial numbering but if we have empty rows in between what formula we should use?

You can you formula for automaticl list number for empty rows

[ItsAustinSea]

Thank you this is the best formula! Perfect for what I needed

[davidlyan]

works great what about if you have to drag an item in the list to a different location within the list?

[sportynumair]

Thank you very much! This was very helpful

[Seychelllian]

Thanks for this. Is there any way to change the increment though? For example I would like the list to be 1.01, 1.02, 1.03 etc instead of 1, 2, 3, 4. Anyone able to assist with that? Thanks!

[oasphil]

Thank you very much! How to automatic list numbering when cells between the list are hidden? Thank you in advance.

[masoodshah]

thank you so much sir but the problem is after adding more rows the formula isn't applied there.

[stephenterry]

I'm doing something similar to what you're trying to teach, but this doesn't work for my purposes. I'd appreciate it if you could reach out to me and you could help me with my specific problem in excel 365 privately. Thanks.

[IsaacLopes]

what if I add a row? the formula isn't applied there. Is there any way of solving that?

[dtwoguntur]

automatic add fresh serial number when empty cell