Dynamic Serial Number | Row | Function
In this video, we will talk about how to create a dynamic serial number column using Row 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).
Now if you’re thinking that one of the ways is to simply enter these serial numbers manually, well – you’re right!
But that’s not the best way to do it.
Imagine having hundreds or thousands of rows for which you need to enter the row number. It would be tedious – and completely unnecessary.
In this video, we will use a function that generates row number and then we will add or subtract it with a fixed number to get the correct serial number.
#shorts #excel #microsoftexcel
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 | Row | Function online without registration, duration hours minute second in high quality. This video was added by user DataCense 31 October 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,341 once and liked it 51 people.