Automatic Serial Number in Excel

Generate Automatic Serial Number, No need to Drag and Drop , Just using easy formula.

[movieverse]

Thank you bro this video really helps me

[rubinrubin]

It was a very helpful video. Thank you.

[yepp]

txh so much, god bless indians
i don't understang anything u say, but u helped me so much

[vakulabaranamu]

Hi, How do I add serial number based on two columns, for eg customer name and date, if I have Customer1 with 5 dates, I need 1 to 5, customer 2 with 4 dates sequence start from 1 to 4. can be done?

[sameerkibatain]

What the benefits if we do this difficult formula? Because if we insert or delete the row then the sequence would be disturb, so we want auto sequence formatting if we add or delete the row

[devakinandan]

=if(B3=isblank(false), "", A2+1)

[unprofessionalpangebyva]

Your voice is like Sushant & Dino the Mix up

[amitray]

but if i delete a row this formula will not work !!! What to do ?

[LatestUpdate]

if condition must nhi ky hr cheez man used ho, their are multiple easy ways jis sy hum increment kr skty hain

[alimohammad]

Wrst method, just type 1, 2 for two rows and then drag selecting both rows

[kiranbandekar]

jaise ki sir 4 + 4 quantity hai.. 1st No pe Quantity Likhu to 5 ve Pe 2nd likha aave, Fir agar me 2nd me quantity Likhu to 5ve vali 3 auto ho jaye aur 6th me 4 likha aa jaye

[irfansalva]

Your voice like Sushant Singh Rajput ❤️😭

[kiranbandekar]

agar me 2nd vali sale me likhu to 2 line Mt ke bad 3 aur 4 aave.. aaise sir

[sauravanand]

Agar koi row bich se delete krna ho to kya wo fir se automatic adjust ho jayega

[rajpingale]

I cant see the formula can u type here. Please sir

[tbhjustforfun]

Bro pata nahi kya ho gaya mera jaise 1, 2 hai ushke karne se sirf upar waala digit hi last take aata hai

[dhavalgorasia]

how to do this when there are multiple tables in single sheet

[francisg]

Sir,
Not visible, please enlarge while explaining.