How to Enter Serial Number in Excel Automatically if have Blank Rows
If you regularly work with lists in Excel, keeping rows numbered automatically can save a lot of time. Most people stuck that what the formula should be applied if they have the bulk data in excel and contains lots of blank rows. =IF(B2=””,””,COUNTA($B$2:B2)) The formula creates dynamic serial numbers that appear only when data is … Read more