Dynamic Serial number in Excel | Insert Dynamic serial number automatically in excel

#dynamicserialnumber
#autogenerateserialnumber
#excelserialnumber

I have explained in this video how to generate dynamic serial numbers by using SUBTOTAL function , with the help of this video you can make your office work easy

Chapters:

00:00 intro
00:16 shortcut key to apply filter in excel
01:13 formula for dynamic serial number
01:33 counta function in excel
04:00 if function with subtotal