Create Dynamic Serial Numbers in Excel & Google Sheets #excel #dynamic #hack #serial #data #filter In this video, you will learn how to maintain serial numbers in Excel or Google Sheets even after sorting (A to Z or Z to A) or applying filters. By default, sorting or filtering data in Excel or Google Sheets often causes serial numbers to become disorganized. Using the SUBTOTAL function, you can create dynamic serial numbers that automatically adjust and remain accurate regardless of how the data

Create a Drop-Down List