Excellent teaching Sir thanks 🇵🇰

Apka formula work nehi kia

V look-up+if and index match 😊

great sir thank you so much for advance data validation...mene to phli bar dekha hai aisa video really me

Could you please share the practice file?

very nice information ❤‍🩹❤‍🩹❤‍🩹

हमें आपकी बहुत जरूरत है sir video upload kar diaa kijie please

Sir aap vidoe upload kyo nhi करते हैं अब

sir you video very helpful for me thank you for sharing. 🙏

Thanks...

Very nice explanation. I saw many videos on KZbin. But I never seen before this type of explanation. Dear sir God bless you.

Sheet delete toh kr skta hain koi bhi Uska solution please

Thank you so much sir

Can we use sequence formula instead if offset formulae

Ek video ki request hai, combo box bna k dikhaen den jisme product category ho, category select krne pe us category k products ki list saamne ajae

9:44 how did you align this by same size very quickly. Kindly guide

Please send this practice excel file to [email protected]

Awesome Sir

Very useful video... But how to filter data with unique name only???

Excellent ❤

At 16:33 , when you use both conditions, why don't you put --

Hi sir.. i need detailed explanation on formula based extracting text from numbers

Sir, very nice. But formula joom kare smile hone par dikhata nhi hai.

Dear sir sabse pahle mera traf se 🙏sir mai apka sabhi video dekh liya aur sabhi downlod bhi kar liya apse mujhe bahut kuchh sikh liya hu lekin ak chij hai jo mai nahi sikha hu aur nahi youtube par koi video upload kiya hai achha se batakar mujhe umid hai app se behtar koi nahi btayega oo chij hai bpo sector se related jaise (srinkege ,atrrition,apr,etc) plz upload video and with practice file .

sir which file you have shared in that file in data sheet some columns are missing like serviceline and employeetype.

Well explained, thanks a lot sir🙏

Can you please show us how to use subtotal and offset with sum product?

can u show to create monthly sheets and dashbord should give month wise present absent and leaves

Kabhi - - laga re , kabhi nhi laga re, kuch bhi matlb😂😂😂

Sir I want to learn SQL and

Fast ki vajhse samj nahi ata hai

Very fast teaching not wel

U can go to format cells and change the standard to customise change to INR and ull get the answer

Bhai choose formula use kark bhi ho sakta hai na ye to

Narrow Minded People will call it Show off, Genius call it Soft Power, Marketing of our Country, Rich Hindu Culture and Tradition.

answer to the homework problem is "2"-- =SUMPRODUCT((B6:B25=I21)*(C6:C25=I22)) you can verify it using countifs function also, =COUNTIFS(B6:B25,I21,C6:C25,I22) and if you want to flex, (like me😁😁) then, =COUNTIFS(B6:B25,INDEX(B6:B25,MATCH(I21,B6:B25,0)),C6:C25,INDEX(C6:C25,MATCH(I22,C6:C25,0))) =COUNTIFS(B6:B25,VLOOKUP(I21,B6:B25,1,0),C6:C25,VLOOKUP(I22,C6:C25,1,0))

Filter formula only 365 I can do excel 2016

Superb.

Sir double negetive sign samjh me agaya mere true ko 1 or false ko 0 karta hai... Jab apne delhi or up ka value nikala tab double negetive use kara okk... Lekin jese hii apne tiisra solution kara usme apne double negetive use nahii kara jesa kii apne bataya hai k text ko Multyply nahii kar sakte value ko.. To third solution me bhii to text tha to ku nahii kara apne negetive sign use... Baki sab samjh me agaya buss yahii confusion nahii ho raha mera clear

Ess attendance sheet me half day ko kese add kr sakte h jisse pta chle ki month me kitne log half days present h???

This is really good, In every view every one discuss only one formula but u clear my concept with the multiple formula in Thank you so much, I appreciate

Sir 1 table mai 6 item hai unka commission nikalna hai 4 other conditions ke sath unme 4 alag alag outlet hai, plus 6 item ke alag alag % hai, alag alag outlet mai??

Amazing tutor

Yeh data mil sakta h

when you used AND (*) you did not use --. Why?

THE DATA FILE YOU SHARED DESCRIPTION IS NOT IN CORRECT FORMAT AND ALSO DATA IS MISSING COULD YOU PLEASE SHARE A PROPER FILE.

It's not working

Very helpful, but what if there is no "cancat" option in excel in that scenario is there any replacement for same?

Sir aap se achha koi nahi samjhata pure KZbin par thanks

Very helpful thanks