New Way to Enter Serial No. in your Data Automatically in Excel (if Row is Blank)

Learn the ultimate time-saving Excel hack in our latest video! Discover how to effortlessly enter serial numbers automatically into your data which contains blank rows also, streamlining your data entry process like never before. Say goodbye to manual input and hello to efficient data management with this simple yet powerful tutorial.

=IF(D2<>"",COUNTA($D$2:D2),"")

Video Tutorial

Download this File

Download All Templates

Join Our Telegram Group

Join Our WhatsApp Group

Nazim Khan (Author) +91 9536250020
[MBA in Finance]

Nazim Khan is an expert in Microsoft Excel. He teaches people how to use it better. He has been doing this for more than ten years. He is running this website (TechGuruPlus.com) and a YouTube channel called "Business Excel" since 2016. He shares useful tips from his own experiences to help others improve their Excel skills and careers.

Leave a Comment Cancel reply