#shorts

Опубликовано: 30 Октябрь 2021
на канале: My Digital Quill
413
14

My Digital Quill | Excel Tips and Tricks #19 | Automatic Serial Numbers for Blank Cells in Excel | Excel Formulas and Functions | Excel #shorts | Excel shortcuts | Excel 365

This example covers on how you can generate dynamic serial numbers in Excel while skipping over the rows with no data. We have utilized two of Excel's key functions here. First one being the IF function with logical test prompting 'true' condition to empty cell and 'false' condition to COUNTA function in excel, which in turn would utilize the presence of the adjacent cell to prompt if the number is to be generated or not.
You can use this example in situations whereby you're either leaving empty rows for the aesthetics of your worksheet or simply waiting to add new data inside. This function can work for you without application of serial numbers each time you add data to your data field

Credits:
Thumbnail Photo by Angela Roma from Pexels
Idea inspired by Ajay Anand:
   • Add Automatic Serial Numbers to a dat...  

Please check out more Excel tips and tricks from the playlist link down below:
   • Excel Tips and Tricks  

Check this playlist for Excel formulas and functions:
   • Excel Formulas and Functions Series  

Free Excel Course available on formatting techniques in here:
   • Excel Formatting Techniques  

🔔 Subscribe for free Office Tutorials at My Digital Quill:
   / @mydigitalquill8945  

#automaticserialnumberinexcel #autoserialnumberforblankcellsinexcel #iffunction #countafunction #countafunctioninexcel #excelscountafunction #Excelformulasandfunctions #Exceltipsandtricks #Excelshorts #excelblankcells #emptydatainexcel #emptycellsinexcel #excelshortcut

#MyDigitalQuill


Смотрите видео #shorts онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал My Digital Quill 30 Октябрь 2021. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 413 раз и оно понравилось 14 посетителям.