Automatically Insert Serial Number in Excel

Automatically insert the serial numbers in Excel when new data is entered in relevant fields by using the IF formula and the ISERROR formula . Watch the Video to know more about adding serial numbers automatically.

10 Most Used Formulas MS Excel

Learn Basic Excel Skills For Beginners || Part 1

10 Most Used Excel Formula
**Most Imporant Excel Formuls Tutorials**

Learn Vlookup Formula For Beginners in Excel

5 Excel Questions Asked in Job Interviews

Create Speedometer Chart In Excel

Learn the Basic of Excel for Beginners || Part 2

Create Pareto Chart In Excel

How to Create Dashboard in Excel

Excel Interview Questions & Answers

Learn Basic Excel Skills For Beginners || Part 1

10 Most Used Excel Formula
**Most Imporant Excel Formuls Tutorials**

Learn Vlookup Formula For Beginners in Excel

5 Excel Questions Asked in Job Interviews

Create Speedometer Chart In Excel

Learn the Basic of Excel for Beginners || Part 2

Create Pareto Chart In Excel

How to Create Dashboard in Excel

Excel Interview Questions & Answers

[KR_Productionn]

Sir meine apke video se bahut knowledge gain ki ausse today i got a job thank you. sir apke bina its was not possible for mei to understand ms excel jaise ap expain karte ho na bahut excellent way hota hai .. thankyou sir the job i got today the credit goes too you....

[syedsulaiman]

I Think this is the better way to make a serial numbers series
Method: put the formula in A1
=if(B1>0, 1"")
then in A2
=if(B2>0, MAX($A$1:A1)+1, "")

it is very useful to me

[dboy]

This was the EXACT thing I have been looking for!!!!  Thank you so much!!!

[justkailash]

Thank you very much for this tutorial i was looking for this one specially as i really dont understand which key work can search this tutorial.. all are tuts are about auto fill when drag the cell.. but i want it it appeal automatic thank you very much .. if you can tell me if i want auto increment with a string like (Alpha-Num) style ID

[sambamurthy]

=subtotal(103, $b$2:b2) and copy the same in the below cells, even you del or add rows it will automatically changes.

[saudmech]

Hi, That can be done with a single formula itself. = if ( b2="", "", a1+1)

[GardeningwithJenny]

Thank you!! Exactly what I needed!! ❤️

hello sir my name is Amit soni I always see your video's & I like it very much this time I have a query i am creating salary sheet now the issue is our company gives monthly one leave to employee after probation period but I have to enter their leaves manually every month in colum so is their any way that the number of leave automatic increases every month

[jpsajimon]

you are doing great!!! Thank you very much

[nabilamer]

if we have two table and we want to apply the automatic serial number to them separately. what VBA code to use say "Table1" & "Tabel2". your assistance is highly appreciated.

[wakaa]

We can use this formula to avoid delete cell like (2 or 3) and all it will come wrong after it cause it will come
just capy it and apply it A1 column
 
=IF(ISBLANK(B1), "", COUNTA($B$1:B1))

thanks

[nareshrana]

Please suggest, if we insert a row in between, than how auto numbering can be fill.

[anildutt]

hi, thanks for your video bro, what if i start with some values like 26.1.1, it has to go like 26.1.2, 26.1.3 and so on, please help me with this. thank you ...

[SandeepVerma-ylkx]

If I want to fill in a column fill only 1 to 50 in one time give formula when 50 is value not fixed it value of another cell

[abdullahfahed]

can i use the same for filtered table ?

[ashivisingh]

if i want to add number between 1 to 1000 in particular range which formula i can use.

[jecalynneparas]

hi! is it possible to put series number on different cells which are located on scattered cells like for example if the series no. 4561which is located in cell no. a3, then i want to have the next series no. 4562 on cell no. b3. is it possible to make excel automatically set it with a formula without manually encoding the sequence of the series no.?

[binayakarmacharya]

This is great but when I delete name list from row 2 and other this result as #value! error how to fix this? thanks.

[m.n.]

hi ..if I have a sheet with 400 rows and three columns . the columns are student name and id number and number of class. .. it is school classes list that every class has deferent number of students …how can I open a new columns that renumber the students every time that the column of class has be changed

[meenubajaj]

I want dynamically serial number in advance filter on another sheet is it possible??
Plz reply