Gazab, excellent 👌👌 Sir ye filter se bhi ho jaayega jaldi ,Jo aapne sikhaya thha Sir Maine aapse ek question Kiya thha sir aapka reply nhi aaya filter formulas se related
Depak sir everything is fine but ap jo b likhen English ma please hindi mijhy ni ati jis wajha sy mujhy kuch chezen samjh ni ati ur link ya information comment specially
Bhai aapki video kaafi ache hoti hai & jitni aasani se aap smjhaate ho wo kaafi taarife kaabil hai . God bless you brother. Awesome teaching skills . Bhut saara pyaar aapko ❤❤ And definitely I add like,comment,subscribe also 😅
Useful information sir Aap apne videos ko ko si category me upload krte h education ya science & technology Agr education h to usme sub category me kya choose krte h
Dear, i m requesting you to kindly prepare a video of Inventory for 26 items, with daily sales opening and closing balance, 3 salesman's are selling all the daily sales of 3 salesman's with shop name also included. Thanks and Regards... Lots of Love and Respect from Pakistan (Because you are my Teacher). Thanks again
Bahut acche sir. Nice impressive vlookup video. Sir main is task ko , vlookup, vlookup+match, vlookup+ coloumns, vlookup+array, index match, offset vlookup se bhi ker sakta huu
@@DeepakEduWorld lekin sir aap ke takreeban sab video ke assigments files mere pass load hain jis per maine bahut practice ki jis se main yw sab sheekh paya. Sirf aap se ik nivedan hai ki vlookup +indirect fuction with sheets and diffrent workbooks is per video banaye. Sirf ik indirect wala concept hi samaj nahi aata bahut try kiya aur bahut video dekhe but clear nahi huaa. Aap ka samjhane ka tareeka samaj mein aane wala hai id liye aap se kaha. Aap ka channel aise harkee karta rahe aur jo kahin fees dene mein asmarth ho wo aap se bahut kuch seekh sakte hai. Danywaad
Thank you aapse sikhne ko mila, i am very happy today. I have one question, while applying either vlook up or Xlookup at one instance its throwing error, this could be a nice case for troubleshooting? would you mind connection on the same?
@@DeepakEduWorldschool report card pe video bna sakte hai? Different subjects like science stream PCB, PCM, jisme students ka subjects mark stream ke anusar roll no wise report card generate ho?
Thank you sir for the informative video. But I would like to add one thing here and that is at 3:47 seconds you have shown that we need to freeze the lookup value ($A$2) which is ok as far as we are dragging the formula to the right side of the cells. But when we will drag down the formula downwards here we will not get exact result rather only the data of (A2) will get dragged down as we have freezed the lookup value. So in order to get the correct data both the sides (right side as well as downwards for rest data) then we need only to free the column A - ($A2) barring the row number so that the formula also gets dragged downwards. Kindly correct me if I am wrong sir.
very nice sir Lekin 1Qustion hai agar 5 ya 10 employee ka data lena hai to Row ko fix kesy karay ghy wo to row number change karna parh raha hai. Please guide me.
Dosto kaisa laga video 😊
Gazab, excellent 👌👌
Sir ye filter se bhi ho jaayega jaldi ,Jo aapne sikhaya thha
Sir Maine aapse ek question Kiya thha sir aapka reply nhi aaya filter formulas se related
THUMBS UP 👍🏻 VELI VELI LEMONI, GABAR 😎 KA ASLI PASAND
You are best the teacher
Depak sir everything is fine but ap jo b likhen English ma please hindi mijhy ni ati jis wajha sy mujhy kuch chezen samjh ni ati ur link ya information comment specially
@@nileshkathe5916 Niles ap ko kesy pta ya recorded video ha
I love watching your excell tricks. They really are worthy of investing time on. I am a big fan of your presentation too.
Always ki traah....super se bhi upar ....100 💯% excellent Excel work
Dear Sir
I regularly watch your videos, and learn a lot from you.
Thank you very much, stay blessed.
Shahid from Pakistan.
Different types of formula by u is interesting. Thank u Sir
Amazing learning Method, watching from Bangladesh 🇧🇩
Ek No🙏
Bhai aapki video kaafi ache hoti hai & jitni aasani se aap smjhaate ho wo kaafi taarife kaabil hai .
God bless you brother.
Awesome teaching skills .
Bhut saara pyaar aapko ❤❤
And definitely I add like,comment,subscribe also 😅
Thank you ❤️ your video made my concepts clear
Bahut shandar sir
Gajab 👏👏👏👌
Thank you I learn something new today.
Even I shared with my friends.
Mind blowing 👌👌 Thank you very much
Very well explained,
You are top class,
Made is simple and explained the functions.
Amazing Baiya 👏
Useful information sir
Aap apne videos ko ko si category me upload krte h education ya science & technology
Agr education h to usme sub category me kya choose krte h
Education
Great ,,, excellent
👍❤❤❤❤❤❤❤❤
I like your last style topic 👍😁
Mind blowing 😊😊😊😊
Dear, i m requesting you to kindly prepare a video of Inventory for 26 items, with daily sales opening and closing balance, 3 salesman's are selling all the daily sales of 3 salesman's with shop name also included.
Thanks and Regards...
Lots of Love and Respect from Pakistan (Because you are my Teacher).
Thanks again
Video like kardiya was epic😂😂😅😅👍👍👍
Awesome deepak
Very nice.
Sir...xlookup download kayese kare dikha dijiye..pls
Very nice sir 🎉🥳🎉
One step ahead ❤
Buhut acha Laga sir
Wao nice vedio
Thank you for great information
Thanks a lot for the video.
Great boss.....sweet and simple with short time and clarity
Column formula ki jagah hum match ka formula bhi use kr sakte h sir it's easy than column 😊😊
Sir apka video se bohot benifit hua but ek question tha, how to use vlookup or hlookup or xlookup or any formula, if whole data in already filtered
No.1 video
👌
Accha laga sir
Bahut acche sir. Nice impressive vlookup video.
Sir main is task ko , vlookup, vlookup+match, vlookup+ coloumns, vlookup+array, index match, offset vlookup se bhi ker sakta huu
Very good prashant 👍👍👍🔥
@@DeepakEduWorld lekin sir aap ke takreeban sab video ke assigments files mere pass load hain jis per maine bahut practice ki jis se main yw sab sheekh paya. Sirf aap se ik nivedan hai ki vlookup +indirect fuction with sheets and diffrent workbooks is per video banaye. Sirf ik indirect wala concept hi samaj nahi aata bahut try kiya aur bahut video dekhe but clear nahi huaa. Aap ka samjhane ka tareeka samaj mein aane wala hai id liye aap se kaha. Aap ka channel aise harkee karta rahe aur jo kahin fees dene mein asmarth ho wo aap se bahut kuch seekh sakte hai. Danywaad
Bahot acha sir😊
good enformation
Very helpful ....super
right from pakistan
Sir very nice video for information ❤
Ek nambar sir
Love you bro nice app achy sy gaide krty Hain thanks
Very nice sir
U r completely saver for us when it comes to excel
Thanks sir aapki wajah se merko bhot zyada appreciate kara hai mere office boss ne thankyou so so much❤ great teacher
Excellent sir
Awesome 👍
Sir mind blowing
Thanku u so much
Thank you aapse sikhne ko mila, i am very happy today.
I have one question, while applying either vlook up or Xlookup at one instance its throwing error, this could be a nice case for troubleshooting? would you mind connection on the same?
Boht Aala barya
You are amazing ❤
Video to accha hai sir. Ek part reh gya. Isko drag down kaise karenge?
I think JB drag down krty Han to formula bilkul thk Kam krta h but JB hum left to right drag krty to issue hota is ly column freeze kr lain gy
Very helpful sir for comparing large data
BHAI JI KAYA MAST DATA DIYA HAI. THANKS
Nice and good explanation.
Masha Allah zabardast
Very helpful... thanks
Thanks for guiding us 🙏
HAPPY GURU PURNIMA SIR 🙏💐🙏
Thanks 🙏 priyanka g… god bless you 🙏
@@DeepakEduWorldschool report card pe video bna sakte hai? Different subjects like science stream PCB, PCM, jisme students ka subjects mark stream ke anusar roll no wise report card generate ho?
1.rohit sharma
2.mohammed siraj
3.logan Ben veek
really v good, informative, easy to understand, video. loved it. thanks
THANKYOU WOULD BE A SMALL WORD FOR THIS KNOWLEDGE WHICH YOU HAS PRIVIDED HERE . . . .. . . . BUT " THANKYOU "
THANK U SOO MUCH ITS A GREAT
Very useful
Very simple explanation
This video was like a lightbulb turning on in my head. So informative and easy to learn and deploy.
Very helpful video sir
Desination❌ Designation ✅
best concept
perfect bro
Bahut accha 😅😅😅😮
well explained
Thank you sir for the informative video.
But I would like to add one thing here and that is at 3:47 seconds you have shown that we need to freeze the lookup value ($A$2) which is ok as far as we are dragging the formula to the right side of the cells. But when we will drag down the formula downwards here we will not get exact result rather only the data of (A2) will get dragged down as we have freezed the lookup value. So in order to get the correct data both the sides (right side as well as downwards for rest data) then we need only to free the column A - ($A2) barring the row number so that the formula also gets dragged downwards.
Kindly correct me if I am wrong sir.
very useful sir
Super
very nice sir Lekin 1Qustion hai agar 5 ya 10 employee ka data lena hai to Row ko fix kesy karay ghy wo to row number change karna parh raha hai. Please guide me.
Sir excel se excel me pay slip banana hai hajaro longo ka please ek video बनाइये
Sir apka course hai kya excel ka buy krna tha
Tq very much sir
🥰thank u sir
nice
Nice sir
Thanks bro
Sir Columns ke alawa Match bhi use kar sakte hai na ?
Xlookup How to Create Mark Sheet in MS Excel step by step Fully Automatic Marksheet In Excel . horizontal to vertical converter
please do it for some compounds data in biology..
Hello sir
Total sales Pe brands wise % kaise nikLte formula banav
Sir, please teach us how to find full record of such a large data from columns into rows throgh vlookup.. Like DMC etc.
Sir plz give formula how you find out DA, CA, HRA, TA etc plzzz
=Lookup value fix, tablet array fix, column (..),0) enter
Amazing
Thank u
Sir, aapka koi online Excel course hai?
Very good
Sir baki Sara clear hai bas ye batiye ki agar multiple colum me se different select kese kare result me for example a b c d e f g h me b d f h .
Separate video jaldi aayega… is topic par ✅
Ok
Nice
Great
Bhai vlookup aur match sath me use kare to bhi hota hai 🤔
Agr empid ke bina empname de diya toh lookup value kya ayegi sirr...?
Bro excel work sheet data kaha sa mile gi jo ap na video mah use ki ha,practice ka lye.
Video ke description me de rakha hai download link ✅
Sir 2d lookup best way kese lagaye match ka use nahi karna he
Wow