Sir use dynamic serial number bolte hein. Explanation of =ROW()-1 1. =ROW() se current row no aata hai (=column() se column number) 2. =ROW()-1 matlab current row joki A2 tha to usko 1 lane ke liye current row(2) - 1 to hua 1.(isse current cell ki value 1 ho gyi) Jisse aapka serial number 1 se start hoga. Aur aage aap dynamic sl no bna sakte ho.
Kash inhone ye video mein bataya hota toh 😂😂😂😂 I was about to comment the same. At least someone took the initiative of being logical rather than cramming 😅
It's good but I've an easy way that I learnt in my computer classes that is 1~ write 1,2,3 2~ select these and just drag no need to even remember that formula which is used in this video or work Thnks
1, ko select karke control ko press kiye hue neeche drag karke bhi aa jayega ya 1,2 select kar drag bhi kar sakte hai sir... Thank u sir for teaching us by formula
Aisa excel mai hota hich nahi hai sare functions excel mai whole column ya row ke har ak cell mai apply hota hai drag karte samay yadi beech mai row ka gap bhi hai to us gap ke baad fir se row number dekhkar function fir se lagana hoga. 🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐
Ise ach to pehle column me 1 likhiye bad me column select kijiye after alt + h + f + i + s click kijiye bad me seris likha huaaa asyega usme last me step value likha hoga usme 1 type kijiye stop value me aap jitna chahiye utne number enter karo aur ok karo
Thank u vaiya. Ye crucial info ye UA-cam wale ne nahi bataya tha. Mai idhar ye trick sikh ke computer me try Kiya aur alag alag row pe alag alag no. ata raha 😂 pagal ho raha tha. Ye adha gyan dete hai log. Mai soch raha tha mera pc kharab hai 😢.
![Advance 🔥 Filter in EXCEL | Excel Interview | MS Excel [Hindi]](http://i.ytimg.com/vi/HGLDKwNaszw/mqdefault.jpg)
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](/img/n.gif)
sahista ne bade ahisita se samjhaya 💕
😂😂
😂
He Prabhu aap ke charan kaha hai......😂
Pichware m
Accha .number dedo
Sahista ji ap aise hi smjaya kro bahut acha samjh aya 🙂
Nice way to convey excel concepts
Shahista is bequtiful❤
Excel ko muskil bnana ka liya bhout Dhanyavaad Gadhi 1 likh kar direct Khich lati
Acha agar koi row bich se delete kaiya jaye to kya wo sr number update ho jay ga agar drag kiya huaa sr ho to???
hum to without formula ke kardete direct drag karke 😂
Bhai tum samjha nhi duabra same galti Hui tuo khud automatically sahi kardega hum drag del ki zarurat nhi baar baar
@@sakshamtyagi3781hum phele sare delete karenge phir drag karenge 😎
Row Insert pe nahi chale ga😢
100000 entries ka kya karoge, naukari se nikale jaoge 🤣🤣🤣
Are automatically karne k liye h..
Sir use dynamic serial number bolte hein.
Explanation of =ROW()-1
1. =ROW() se current row no aata hai (=column() se column number)
2. =ROW()-1 matlab current row joki A2 tha to usko 1 lane ke liye current row(2) - 1 to hua 1.(isse current cell ki value 1 ho gyi) Jisse aapka serial number 1 se start hoga. Aur aage aap dynamic sl no bna sakte ho.
Kash inhone ye video mein bataya hota toh 😂😂😂😂
I was about to comment the same.
At least someone took the initiative of being logical rather than cramming 😅
I like your confidence level..all are facts and the way you representing everyone wants to listen..keep going...❤❤❤🎉
Aap asa vidio banate hi rhia bhai thank you
I appreciate 🎉 for this excel formula
It's good but I've an easy way that I learnt in my computer classes that is
1~ write 1,2,3
2~ select these and just drag no need to even remember that formula which is used in this video or work
Thnks
I use =row(A1) works fine
*Men of culture, we met again 🗿*
_Jo tum soch rahe ho, wohi mai soch raha hu 🥂_
Wao
Nice nice ❤
Thanks
Shaista buht cute he❤❤ love from Pakistan 🇵🇰
😂😂
Thank you 👏
Shaista is fantastic ❤
Wow Great info 🤩👌👌!!
Love and thanks from Pakistan 🇵🇰
Just use =sequence (number of serial number )
Easy peasy
Excel me aasan tarika bhi hota hai
thanks for making understand us 😊
I face this problem every time.... here is solution 🎉
Thank you ❤️
@@bdscomputer
Keep posting indepth ideas, tricks and teaching
Everything is super useful.
Beginner cannot understand until they face the situation
Zabardast ❤
Good one
Tankyou sahista❤❤❤❤❤❤❤❤❤❤❤
Very cute Sahista
अरे ये राधिका औऱ सपना से हिट है, love u बेबी यार 😅
Aap ka class mei ham ko jane ka man kar raha hai. Sikh na hai ham ko bhi. Men will be men
Wowwwww... Beautiful.... But Row add krne pe ye work kre aisa v formula btayie sahistaa
Sahista is cute 🥰
All select krne ke bad ... Alt + E S Ipress kr ke enter button pr clik kr de .... Bilkul aasan
How?
@@priyanka6649 simple
Thanks it's very helpful
Insert column karana ho 1 column chhodkar fir 1 column add karana ho multiple kaise hoga
This is really useful information
isase achha 1 2 likh kar drag kardo jaldi ho jayega ya jaha se badla ho wahi ke upar do row select kar lijiye aur drag kar dijiye... that's it
1, ko select karke control ko press kiye hue neeche drag karke bhi aa jayega ya 1,2 select kar drag bhi kar sakte hai sir... Thank u sir for teaching us by formula
Shi kha apne itna long formula lgane ki jrurat hi nhi he sirf 1 or 2 vali scale dono ko drag krke down krte jao jha tk jana ho
Bt agr apne notice kiya ho baad m jb usne row delete kri toh serial no. Automatically update ho gya...
Agr hum normal krke drag krnege toh automatically update nhi hgi ..haar baar khud s krni pdegi
@@mayurigarg7457 haji ye to shi bola apne mene sirf drag krke numerical counting kr skte h us liye reply diya tha mayuri ji
Bilkul
achi information hai bohot kaam aaegi mere😅😅
Saaabbbbas bitiya❤😅
Very good 👍 gril weldan 😮❤❤
Agar add karna ho tu
ye to us row ko count krta h jnha pr h. yadi h d7 pr ye formula lgate hn to ismein thora changing krna prtah. but ek fourmula jo knhi pe lga skte hn.
Very helpfull thank q
Really cool 👍
Its only applicable when your data starts from row 1 but when u start from row 7 or 10 etc after heading it will not work
Just do -7 or -10 for that case, easy 🤷
@@shivangrathorewhat if there will be a gap between rows
=Row( )-Row($A$2)
try this
A means collum no
2 means row no.
Aisa excel mai hota hich nahi hai sare functions excel mai whole column ya row ke har ak cell mai apply hota hai drag karte samay yadi beech mai row ka gap bhi hai to us gap ke baad fir se row number dekhkar function fir se lagana hoga. 🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐🧐
bro this formula shows row number. So if your want your 10th row to be noted as serial no 1 then just type =row()-9
Shaista 😊
Wah uncle wah
Superb 👌❤
Thank sir
Awesome thanks sir
Bahut lengthy hai,1aur 2 ko select kro jab chota +show hoga tab down side drag kro to ho jayega,bahut simple hai aur short bhi
Thanks Saista jeee .. Mai v sikh liya
Bahut badya
Select Row & delete, Select all =row()-1 Enter & dreak all & Done
Thanks You Sir , Awesome Trick 🙏
Helpful
Nice wayyy
Too good
Shaista .... Voice😌😌
=Row()-1
Excel or Ms office kaa matlab mouse ko bina touch kiye kaam karo tabhi expeet maane jaoge....
This formula is based on excel rows no.
- like we working on row no 22 and use this formula then we get 21 of our working row.
Yes I also tried and same happened
It's helpful.. thanks
Great 💯👏👍👍
Thanks
Data entry ki job karna h sir ko. Sa course karu
Superb!
Thank you
But if someone add the row on top of table, maybe Number can change cause you taken reference of number from row number ruller bar
2 ko upper cell+1 kro. Or drag kro toh kuch bhi delete kro result ese hi aata hai serial wise.
Thanks😊
Welcome 😊
Good 👍
Sir kya agar filter lga hai to ye formula kaam karega
Plz reply dijiye 🙏🏻
Ise ach to pehle column me 1 likhiye bad me column select kijiye after alt + h + f + i + s click kijiye bad me seris likha huaaa asyega usme last me step value likha hoga usme 1 type kijiye stop value me aap jitna chahiye utne number enter karo aur ok karo
I Love you 😘💓❤
=row()-1 enter bottom click krenge thank you 😊
aapko vhi no likhna hai jis no ke row me aaap ho us se ek kam , ager aap 10th row pe ho to formula hoga =ROW()-9
Ok thanks
Thank u vaiya. Ye crucial info ye UA-cam wale ne nahi bataya tha. Mai idhar ye trick sikh ke computer me try Kiya aur alag alag row pe alag alag no. ata raha 😂 pagal ho raha tha. Ye adha gyan dete hai log. Mai soch raha tha mera pc kharab hai 😢.
🎉❤
Isse bhi easy trick hai
Saista mujhe achchi lgi... isrf Saista ki wajah se maine video 5-6 baar dekha 😎😎
Yes! Cause she is your sister 😂
Kya filter apply krne bad bhi ye formula work krega ?
Easy formula= 1+1
😂
Ek kaam kariye, top mein do blank row insert kijiye
Row no 1 me auto fill me + ka sign aega to drag kijiye sereal no ajaega
Thx 🙏
Formula apply karni k bad Kya kihrahe te Yi sir darik eske bat Chang Karli ...pir Yaha SI k bad Kya kihrahe te
I want to learn complete excel
Outdated formula he, sequence formula use karo nahi to subtotal use karo. =Sequence() and hit enter fully dynamic
Very good 👍
I like sahista
Sahista: Hello Mahila helpline
😂
@@ArvindKumar-fu3zy😂
An XL formula that adds the serial number to the data once should not be added again
Sahista l love you
Agar row blank hoga toh kya karoge ?
Nice
Mil Gai shishta😂😂😂😂
Excel m dashboard banane ka vdo dalo
Sab se best idea doon ctrl Z click kariye automatically ajayega bhai😅
Very impressive. Keep it up.
Super
Sir full sheet capital letter me hai kaisae vo proper lettermen karega full sheet
❤❤❤👍🏻👍🏻👍🏻
Sir Excel m discount amount pe GST 18%lagana hai phir.25 insurance add karna hai uske liye koi formula
Ab Tak tum UA-cam PE search marta to mil jata ye sala sachita k chakkar me h bs
Par add row krenge to nahi hoga
Sir I have question
There is a data of college students marks I want to find how many students get re appear in list
Good