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
On this page of the site you can watch the video online Dynamic Serial Number | Row | Function with a duration of hours minute second in good quality, which was uploaded by the user DataCense 31 October 2020, share the link with friends and acquaintances, this video has already been watched 1,341 times on youtube and it was liked by 51 viewers. Enjoy your viewing!
