agar aapke paas 365 nahi h to automatically s. no. ke liye for use kro B5 me =IF(D5"",ROW()-4,"") aur heading dalo B4 me serial no.aur c4 me name aur b5 ko drag kr do door tak ab C coloum me entry krte jao aur automatically serial no. aayega mai ye for mula ms excel 2019 me use krta hu
Thank you sir thankyou so much ki ap ne itni pyari pyari or intrusting computer video ap ne hamare liye banai or hame computer ke software ke bare me sikhaya padhaya or itne pare or intrusting tatike se ap ne hame ms word ms excel powerpoint photoshop page maker coreldrow bahut ache tatike se hamako padhaya ot mene coching nahi balki apki video se ghar pr hi sab kuch sikha or apka padhane ka tarika ap samjhane ka tatika mujhe bahut pasand aaya thank you sir thankyou so much sir thank you thankyou thankyou sir👍
This can be achieved by this formula also: =IF(B2="","",SUBTOTAL(3,$B$2:B2)) I have been using it for so many years. This formula serves two purposes: 1. If you delete data starting from B2, the serial number will also be deleted, and the subsequent cells will maintain the serial number sequence. For example, if we delete data from B3, the serial number in A3 will be deleted, and the serial number in A4 will start from 2. 2. If you filter your data, the serial numbers will follow the sequence based on the filtered data. For instance, if you have more data and Delhi is mentioned five times. When you filter your data by Delhi, the serial numbers will range from 1 to 5. This eliminates the need to correct the serial numbers after filtering.
Sir delete kiya 4 ya 5 no. Ok, but if add some data in between already rows. Sometime we add data according to date. But kuch time baad pata chalta hai ek date missing ho gai, tab hame upar ja kar date add karte hai, or pura column likhte hai, tab bhi kya ye sequence formula kaam karega
Aasif sir jab muskurate hai to un ke gaal mere ko bahut achhe lagte hai dua hai ke aasif sir aur satish sir aur jitne bhi aap ke team members hai un sab. Ko allah aaise hi muskurate rakhe (آمین )
Sir koi aisa tarika hai hai jo kewal number ko ki count kare jaise A1 me 5kg 4 pkt ho aur B1 me 5t , 4l td hai to sabhi ko jodne par kewal number ko jode ya guna kare kaise kar sakte hain
SIR MERE PASS AK EXCEL SHETBME JIS MERE STOCK ITEM KE KAME OR OR UNKI SIZE HAI TO MUJH YE CHAHIYE KI ME STOCK ITEM KE MANE KE STARTING KLKE2NWORD TYPE KARU OR VO STOCK KA ANAME PURA AA JAYE
Sir agar main middle ka kohi cell blank rakhu or uske baad ka row main serial no. Blank cell se pehela cell ka serial no. ke baad continue Nehi aa Raha hai.. Bo blank cell ko v pakar ke aa raha hai.. plz give the solution...
![⭐ฮิตในTikTok!! ( หมูเด้ง MooDeng ) Ver. แดนซ์โจ๊ะๆ ReMix BY [ ดีเจกิต รีมิกซ์ ]](http://i.ytimg.com/vi/3krsyfWUeHU/mqdefault.jpg)
Perfect explanation. Thanks Mr. Asif and Mr. Satish. From Kuwait
4 din pahle hi mere dimagh me ye saval Aya tha ki kash Aisa hota . Aur aaj mil gaya.
Thank you so much 🙏🙏🙏🙏
agar aapke paas 365 nahi h to automatically s. no. ke liye for use kro B5 me =IF(D5"",ROW()-4,"") aur heading dalo B4 me serial no.aur c4 me name aur b5 ko drag kr do door tak ab C coloum me entry krte jao aur automatically serial no. aayega mai ye for mula ms excel 2019 me use krta hu
Excellent Teaching...Asif Sir your Genius...The way of Teaching is Simple and Very Effective....Thank you
Sir u r great teacher of excell.
labour's Teacher or Slave's Teacher
Excellent teaching. Thank you Sir. 🙏
This formula also works in google sheets perfectly. Thank you sir !
The new Excel trick is amazing. Thank you very much for giving such amazing information. (Asif Sir ❤👌)
Really appreciate your teaching
Bahut hi acchi jankari di sir, thanks
Mind-blowing formula🎉
Wow .... Acche se explain kiya sir aap dono ne 🎉
Hmm❤
Clear
Sir aggregate to lengthy we use short formula on there
=if(B2="","",row(1:1)) and drag formula please check my formula
Deepak sir is excellent in teaching excel
Thank you sir thankyou so much ki ap ne itni pyari pyari or intrusting computer video ap ne hamare liye banai or hame computer ke software ke bare me sikhaya padhaya or itne pare or intrusting tatike se ap ne hame ms word ms excel powerpoint photoshop page maker coreldrow bahut ache tatike se hamako padhaya ot mene coching nahi balki apki video se ghar pr hi sab kuch sikha or apka padhane ka tarika ap samjhane ka tatika mujhe bahut pasand aaya thank you sir thankyou so much sir thank you thankyou thankyou sir👍
IT IS DONE SIR. I OPENED A NEW FILE AND IT WORKED.
THANK YOU SIR. AWESOME VIDEO. SIR, AUR BHI PRACTICAL VIDEO DALTE RAHIYE.
Very helpful video....Please bring such videos for different formulas in Excel in future.
What about the sequence formula if there are hidden rows, will the serial be affected or it would remain same
Bahut khoob aap logo ki efforts
एकदम clear 😊
Nice logic and clear details
Everyday some Jabardast dhamal type of contents given by U both Sir.. Really appreciate it 😇😇👍👍🙏🙏👌👌
Thank you so much!!
Thanks satish sir , that question came in my mind & you just ask this after 10 second
Excellent teaching Sir Thank You So Much Sir 🙏
Bahut accha Asif sir great ❤
Sir excel ka sath ka sath combination kon ka kra
Firstly I thought why its need but now it's amazing trick
Clear Sir, Very Nice
Aggrigate me agar cell delate karege to kya Sequence ki tarah react karega?
Sir row hide krne ya filter use krne pr serial number sequence me rhega ya nhi
Mr.Asfi sir, so charming ❤️
Clear sir thanku so much 😊❤
This can be achieved by this formula also:
=IF(B2="","",SUBTOTAL(3,$B$2:B2))
I have been using it for so many years. This formula serves two purposes:
1. If you delete data starting from B2, the serial number will also be deleted, and the subsequent cells will maintain the serial number sequence. For example, if we delete data from B3, the serial number in A3 will be deleted, and the serial number in A4 will start from 2.
2. If you filter your data, the serial numbers will follow the sequence based on the filtered data. For instance, if you have more data and Delhi is mentioned five times. When you filter your data by Delhi, the serial numbers will range from 1 to 5. This eliminates the need to correct the serial numbers after filtering.
Interesting discussion between you two ❤
Waah mja aa gya 🎉❤
Sir, is there any formula to mark a cell yellow in Google sheet where the date is 2 month before or after current date
Sir delete kiya 4 ya 5 no. Ok, but if add some data in between already rows. Sometime we add data according to date. But kuch time baad pata chalta hai ek date missing ho gai, tab hame upar ja kar date add karte hai, or pura column likhte hai, tab bhi kya ye sequence formula kaam karega
Superb video
🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹
सीखते रहो, सिखाते रहो l
हमेशा हंसते मुस्कुराते रहो l कभी अपने लिए तो कभी अपनों के लिए l
Super video sir. Thanks so much.
Got it explained very well. I am your customer of your pen drive course.
Thank you sir...
Super
Very nice information sir, Thanks 🙏
Well done Asif Sir
Sir Blender Software Ka Full Tutorial Banaye Learn More Channel Par PLZ Reply Kab Banayege namaste 🙏
Very nice teaching sir
Sir office 2021 mein bhi available nhi h aggregate formula.
Very useful class sir ❤❤❤❤❤❤
Thank you
Thank you so much
Awesome Hai Sir.
Amezing ❤❤ thank you to updated us
Excellent.
सर फ़िल्टर फंक्शन के साथ काउंट फॉर्मूला यूज करना भी सिखाइये। with लॉजिक
Bahut badiya
Sir,
I want to learn power pivot Please design the course...
Video link : th-cam.com/video/9QiW7jefEms/w-d-xo.html
Hi, can we contact directly and sit for training upon our work related required information can be provided?
Sure kindly contact info@satishdhawale.com
Excellent
Good. Hv to learn all fast and daily.
Sir =Row()-1 Searial Number ka Formula Hai
Zakkas❤🎉
Aasif sir jab muskurate hai to un ke gaal mere ko bahut achhe lagte hai
dua hai ke aasif sir aur satish sir aur jitne bhi aap ke team members hai un sab. Ko allah aaise hi muskurate rakhe
(آمین )
Amazing trick sir
Sir aap webinar ka video TH-cam pe upload kyo nhi karte hy.
Please sir TH-cam pe upload kar dijiye jise kavi v dekh skte hy
Sir mai aapka course buy karna ka think kar rah hu kya yeh update aapke course mai available hai
Hanji ye naye formulas bhi update kiye hai humne
Bhai kr liya kya course purchase
@@rajasthanwalaa Nahi kyu?
Helpful trick hai sir 😊
Sir koi aisa tarika hai hai jo kewal number ko ki count kare jaise A1 me 5kg 4 pkt ho aur B1 me 5t , 4l td hai to sabhi ko jodne par kewal number ko jode ya guna kare kaise kar sakte hain
Very nice sir
Very nice sir. Well explained. I am from Pakistan. And what is the name of Asif sir channel
Sir excel me agar ek hi column me data hai to usko kaise separate karenge bina text to column ke..pls is topic par video banaaiye..
You can use left & right function and even use Len if you want specific length of data you want to extract.
Very nice
Wonderful ❤
Very nice ❤
Appreciate you
sahib
type 1 in A1
in A2 type this formula
=if(B2="","",A1+1)
pull it to whatever length you want
Correct ji
Sir office 7/10 v ho jeyega
If formula or Row Formula se
Thanks sir
Nice🎉
Super Sir
Master class
Kindly fill the form given in the description
Vrey Good
Sir, i want to learn online courses like data entry, advance exel and advance tally.
Those who don't have aggregate function in older version of excel can use if formula as
=if(B2="","",COUNTA($B$2:B2))
Great!
Dear hum excel ke 2019 me sequence function kaise use kare pls
3 comment mera hai😅 bhut accha video 🎉🎉❤❤❤❤
Account different head and sum pr video bnao
Will do that
Sir.
I have got error in using =if(B2="","",aggregate(3,5,$B$2:B2)) formula like #Name?.
Please help on the same.
Sir i am getting a spill error using the sequence formula with count a
I think you should repeat the formula twice so we can understand better and get chance to write in our notebook
You can achieve the same result dynamically using a combination of the IF and ROW formulas. =IF(B3"",ROW(A1),"")
Yes you are right 👍
Clear sir
Nice.
Thanks.
Shakeel Ahmad
Karachi, Pakistan.
Sir Excel se tally me entry kaise kare
सर जी excel में उदाहरण 90.45.600 कैसे लिखें दशमलव संख्या कैसे बढ़ाये और टोटल भी डबल दशमलव मे आए कृपया कोई वीडियो मे समझाये
SIR MERE PASS AK EXCEL SHETBME JIS MERE STOCK ITEM KE KAME OR OR UNKI SIZE HAI TO MUJH YE CHAHIYE KI ME STOCK ITEM KE MANE KE STARTING KLKE2NWORD TYPE KARU OR VO STOCK KA ANAME PURA AA JAYE
WPS me kr skte ho jinke pas 365 nhi hai
Great
Sir agar main middle ka kohi cell blank rakhu or uske baad ka row main serial no. Blank cell se pehela cell ka serial no. ke baad continue Nehi aa Raha hai.. Bo blank cell ko v pakar ke aa raha hai.. plz give the solution...