How to automate serial numbers in excel skipping blank rows

#AutomaticSerial #shorts
Learn how to automate serial numbers in excel skipping blanks

[kriszelda]

Finally, I found the formula that really works 🥳 clear and simple. Thanks 🙏🏻

[anikamazed]

Thank you brother so much. It helps me a lot. It feels like God re-directly helped me

[TOM_M]

Sir, i have one doubt.. is this possible to change one sheet data automatically changed to another sheet using vlookup function? Pls tell me How to use it

[anupreetborkar]

Thank you. I was looking for similar solution. It worked for me. Just that I had to change the Cell Format from Text to General for this to work for me.

[udhayakumar]

is it possible to create a custom value instead of just a numbered series from 1-100

[KhairulMardhiahAbidin]

I want to make numbered list like this but instead of blank i have the repetitive names and i want to consider all the same name come as one, is there any solution to this?

[navaneethakannang]

I want to start again with 1, after that blank rows. How to find out.
Example 1, 1, 2, 1, 2, 3 kindly advise me..

[yohanj]

any suggestion to get alphabetical letter

[phillips]

I want to copy the fomular skipping rows