Excel formula to create Automatic Serial Numbers
HTML-код
- Опубликовано: 11 апр 2024
- Excel formula to create Automatic Serial Numbers is explained in this short video.
🍐Join my online course on Excel Tables
www.udemy.com/course/tables-i...
🍓Download my free eBook on Excel Macros
eepurl.com/gpT0RD
🍇Check these Books on Excel
xlncad.com/excel-resources/
🍉Read my articles on Excel
xlncad.com/
🍏Playlist for Shorts on Excel
• Short videos on Excel ...
#excelshorts #automaticserialnumber #exceltricks
Thank u 🎉
Delete works only if we delete using right click context menu 😢... Not by hitting del key 🗝
You can use keyboard cntl and - key
Thanks for sharing
Plz add Tibet in country list. Thanks 🙏
How it's possible in different column in one table with continues number like one column 1-20 another one 21-40
What is 1here?
How date will come automatice base on a other column
Can also be done by using if + counta
Could you explain
@lazyreviewssupport9811
Let's say your serial number start in A2
And data start in B2
Use this in A2 cell
=IF(B2"", COUNTA($B$2:B2), "")
Then drag it down to your desire range.
This formula checks if cell B2 is not empty (""). If it contains data, it counts the number of non-empty cells from $B$2 to the current cell B2 using COUNTA($B$2:B2). This count is used as the serial number. If cell B2 is empty, it returns an empty string ("").
i want it in this way, if you can help.
SR.No in column A.
If i enter a value in column B,
then it generates SR.No. in column A.
Also their are blank rows in Column B
(if i enter a value in B1, then it Auto generates SR.No._1 in A1,
then i enter value in B6, and it Auto genarates SR.No._2 in A6,
and so on........
Put this formula in A2
=IF(B2"", COUNTA($B$2:B2), "")
Then drag the formula in A2 down to the end of your desired range.
Its not working