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