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
Смотрите видео Dynamic Serial Number | Row | Function онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь DataCense 31 Октябрь 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,341 раз и оно понравилось 51 людям.