Dynamic Serial Number | Filtered Data |
In this video, we will talk about how to create a dynamic serial number for the Filtered Data column using SUBTOTAL and COUNTA function
When working with Excel, there are some small tasks that need to be done quite often. Knowing the ‘right way’ can save you a great deal of time.
One such simple task is to number the rows of a dataset in Excel (also known as the serial numbers in a dataset).
In this video, we will talk about how to maintain the continuity of serial numbers even when the data is filtered. This means how to again start the serial numbers from 1 and then extend it only for the filtered data.
Imagine having multiple filters in your sheet/table during the data exploration and then if the serial numbers are still following the order automatically isn't that awesome.
We will use a counta function to count the rows and the subtotal function will make sure to do the counting only on the visible data.
#shorts
Also, check these videos if you want to learn more
1 Min Excel: If you enjoy short videos check this section
• Shorts : Random
Excel: Check this playlist for Excel-related things
• Excel
Keyboard Shortcuts: Check this section to save some time in everyday excel work
• Excel Keyboard Shortcuts
Pivot Tables: Check this playlist for Pivot Table, Slicers, and Auto refreshing reports
• Pivot Tables
Power Query: Check the Power Query playlist for Data Preparation & its Automation
• Power Query
Power BI: Check the PowerBI related videos for Business Intelligence, Dashboard & Visualisations
• Power BI
Please subscribe to our channel and Follow us on other social media platforms for regular updates :
Tiktok https://vm.tiktok.com/ZSH28XEt/
Facebook / datacense
Twitter / datacense
LinkedIn / datacense
Instagram / datacense32
Watch video Dynamic Serial Number | Filtered Data | online without registration, duration hours minute second in high quality. This video was added by user DataCense 07 November 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 633 once and liked it 33 people.