Subtotal Formula to create a never changing changing serial number in excel
Subtotal Formula to create a never changing changing serial number in excel even if I use filter. This is one magical function which can help you to create a sequential order of serial number and the number will not changed with filter or sorting. Among so many functions of excel we will use the CountA function to let the magic happe.
Stick to my channel and subscribe to OnlyDreamScape please.
Thanks to the talented DGM(Accounts and Finance) of Bashundhara Shipbuilding Zahid Sir who has taught me this functionality of subtotal. I’m really grateful for that.
Subtotal
Subtotal Formula
create not changing list in excel
CountA
List building
Sequential order
Listing
Never changing Serial number
Serial number problem solved
Microsoft excel
School of excel
Excel function subtotal
Excel function CountA
Serial number in excel