Dynamic Serial Number in Excel

Hello Friends,
In this video you will learn how to create dynamic Serial Number in Excel.

Please download this excel file from below given link:

Watch the best info-graphics and dynamic charts from below link:

Facebook:

Telegram:

blogger:

Twitter:

Send me your queries on telegram:
@PKanExcelExpert

[chavelooo]

You are the best, Simple organized and clear. Thanks a lot. Save me time looking for videos on the web

[raliyev]

Good one! In some cases it is a good idea to use "103" instead of "3" in SUBTOTAL function to ignore manually hidden values.

[shivdeshOfficial]

Dear Respected sir your voice is very sweet 😋

[pardhu]

Brother you solved my problem thank you.😀

[JaagrookBhartiye]

=IF(C2="", "", SUBTOTAL(3, $C$2:C2))
this formula doesn't work online on MS Teams, as "serial number", it goes to 0000 and then and then and so on...
is it possible to shed some light how to solve this issue with online excel spreadsheet, please?
All I need is a column with serial numbers on my online (MS Teams) excel spreadsheet, which works even after "filtering" the data.

[ahmadaltayeb]

Sir thanks it's work in a normal table, but not work when I make "Format as Table" from Home Menu, Please advice.

[meenubajaj]

This video made my day thankyou so much

[pradyatdani]

Sir, Having learnt from your video I applied the function to create dynamic serial number, so a big thank you for you. But sorry to say that, when I copied the data to sheet no 2 it didn't work. Would you mind to help me in this regard by providing your Email id which enable me to send the excel file to you for necessary correction.

[NagaRaju-bqlk]

It is good .regarding this sheet I want automatically serial number also pls help me

[ManikandanRaju]

Thanks a lot buddy! Wonderful learning.

[fullofenergy]

Thanks for your video my friend.

Can we create a unique ID following the values from first two columns. For example; B2 & C2 have unique values whereas A1 should read and create a unique ID (text&num) and if same values in B2 & C2 are reentered, it should return with same id rather than creating a new ID

[ruroshinzynaruto]

Thank you for this amazing idea, how we can do the same to add seq number in Pivot Table, after generating data.

[mukundpotdar]

Hi

I have a question, Is there any way to automate this formula rather than dragging or copying the formula to different cells ?. Is there any macro we can automate this task and allow user to enter data from second column directly ?

Kind Regards,
Mukund

[AsifBoss]

If data is zero by formula in data cell then how to use this formula to not count this row in serial

[purwadiyoga]

Are this formula work in arrayformula?

[sejalparange]

Sir apane jo uper heding mai series no and Emp id, or puri line stop hai or ap baki niceka sara deta scroll karke dekh sakato ho toh oh heding stop kaise karate hai?

[meenubajaj]

I want same dynamically serial no. In advance filter on another sheet is it possible??
Plz reply

[myimaanofficial]

Its not working when I enter any other data in row, it should show the number automatically

[secretsgaming]

how to auto generate this series 2051/21 next 2052/21 and 2053/21

[Rvetri]

Hi i tried this formula but starting number 2.. could you pls help