निवेदन है की आप जो डाटा यूज करते है उसको भी अपलोड कर दिया करे जिससे हम उसको डाउनलोड करके प्रैक्टिस कर सके बाकी आपका तरीका बहुत बेहतरीन लगा , आपका पहला वीडियो देखा है अच्छा लगा। धन्यवाद
Bahut achhe tarah se koi bhi topic samjhate hai aap.thanks Ager 2022 me employees ki sankhya increase ho 2021 ki tulana me aur 2024 me employees ghatkar jae 2021 se 2023 ki tulana me to us condition me kaun si table ko value denge Aur yadi 2024 me nae employees jude jinka naam pichale years me na ho to fir kya karna hoga
Instead of manually changing formulas for other three columns use {2,3,4,5} must be in curly brackets. This is the formula i used on my data: =VLOOKUP($E$8,SWITCH($L$5,2021,Table1,2022,Table2,2023,Table3),{2,3,4,5},0)
Sir please is topic par ek video bana dijiye. Sir mere paas excel ki ek sheet hai jisme 1 month ka bahut bada data hai, jisme bahut sare bill no same hai lekin amount different hai, mujhe aise report banani hai use match karne ke liye, ki sare same bill no wale ka total amount show ho jaye. & Sare sheet pe apply ho jaye. Sir please reply kijiyega
सर एक विडियो में बताईए की जिस कम्पनी में data entry karne ko kaise aata hai aur usme email ya document me aur kya kya us data me se enter karna hota hai
Sir excell formula se bhara hua hain kitna formula yad rakhu .. koi aisa tricks hai ki kam karte karte jaisa problem aya bina formula yad rakhe kar pau
Sir factory ma football banay jaty hai on ko computer par scane kar KY bad ma btana Hota hai kis ny kitny football banay hai asi koi video hai tu plz link send kar dy 🙏🙏🙏
Ye bekar ka function use karke time waste mat Karo is case main sidha table ka name hi change karde for ex- Yr2021,Yr2022 then use it as vlookup table name 🦄🧐
Sir agar 4 sheet ka data hai aur us subhi data ko 1 hi sheet mai merge krna hai toh wo kaise kre vstack ka use krte hai but samgh ni aya pls jaldi video bna ke dale hamara interview hone wala hai
What an tremendous lecture.... Just waooooooo 😮😮😮
Very good tropic , thank you sir
बहुत ही आसान तरीके से समझाया । धन्यवाद ।😊
Bahut accha laga aapki video dekhne ke bad or samaj mai bhi aa gya hai.
Sir Mai ne der sare teacher deke lekn AP jaisa Mai heran ho sir apki teaching bahut zabrdast hai ❤❤❤
Nicey ❤❤ learning to students
It felt pretty great
Lookup ke sb formule ka cideo bnaiye
Sir All amazing video 😊
निवेदन है की आप जो डाटा यूज करते है उसको भी अपलोड कर दिया करे जिससे हम उसको डाउनलोड करके प्रैक्टिस कर सके बाकी आपका तरीका बहुत बेहतरीन लगा , आपका पहला वीडियो देखा है अच्छा लगा। धन्यवाद
Amazing video sir❤
khup chaan
Very nice good 👍
Useful video sir. 🙏
thank you sir nicly explained
Informative video sir ❤👍
Very nice sir
Thanks Jani..... 🎉 very helpful video ❤
Very nice
Excellent bro
easily learned , lot of thanks from Nepal
Amazing tutorial.❤
Thank you sir
It was really amazing 😊😊 god bless u
V.good sir
Amazing brother
Iam big fan sir from Pakistan,❤
Nice❤
Nice
Great sir
❤❤❤
Thank you sir 🙏🙏🙏
Bhai super yr soo amezing
Achche teacher bahut hi kam he face to face padhne par.😐😶🥴
Very nice sir 👍
Hello mam
Acha hai
Thannks sir Muje aap se proper excel sikhna hai aap se pls help me
Please provide the dataset sir
sir...match k bajay coloum ko bhi use ke skte hain.
Thank you sir.
Can I apply this formula in HLOOKUP also?
Very informative , Thank you. Will it be possible for you to share this excel sheet to practice ?
amazing video sir,but sir also provide pratice sheet for pratice
Bahut achhe tarah se koi bhi topic samjhate hai aap.thanks
Ager 2022 me employees ki sankhya increase ho 2021 ki tulana me aur 2024 me employees ghatkar jae 2021 se 2023 ki tulana me to us condition me kaun si table ko value denge
Aur yadi 2024 me nae employees jude jinka naam pichale years me na ho to fir kya karna hoga
Thanks
We can use IFS condition ?
Pls provide dataset sir🎉🎉❤❤
Bro i need some is my file we selected id number instead of sales year there also should id number change automatically how if any formula
Bank statement excel pe kease entry kare sir
Sir excel ka all class sir
Vlookup and indirect se bhi kar skte hai
Can I use this for Google sheets??
Instead of manually changing formulas for other three columns use {2,3,4,5} must be in curly brackets.
This is the formula i used on my data:
=VLOOKUP($E$8,SWITCH($L$5,2021,Table1,2022,Table2,2023,Table3),{2,3,4,5},0)
How to view full data without dropdown in the master sheet
First view
Bhai kya hum loag is formula ko use karke total karsakte ho kya?
Agar colums ke liye {2,3,4},0 se hoga?
Practice के लिए data sheet provide करना चाहिए आपको
Sir please is topic par ek video bana dijiye.
Sir mere paas excel ki ek sheet hai jisme 1 month ka bahut bada data hai, jisme bahut sare bill no same hai lekin amount different hai, mujhe aise report banani hai use match karne ke liye, ki sare same bill no wale ka total amount show ho jaye.
& Sare sheet pe apply ho jaye. Sir please reply kijiyega
Maine ye sb vlookup bhi kiya hai
Sir plz aapse request hai ki aap ek video esi or banao ki ek sheet m ek name two times hai to us pr vlookup kaise use karna hai
By Id
Bhai agr headers aage piche ho?
MySQL pr video banao bro please...
Bhai please sath me practice file bhi share kar diya kro 🙏
सर एक विडियो में बताईए की जिस कम्पनी में data entry karne ko kaise aata hai aur usme email ya document me aur kya kya us data me se enter karna hota hai
Sir Excel mai Swich formula hi nahi aa raha kya kare
Sir attendance sheet ko bie vlookup me ke se dekhe
Hello sir if switch function is not working what will we do?
Sir ye work (xlookup) sy nai ho skta kindly explain this
Sir excell formula se bhara hua hain kitna formula yad rakhu .. koi aisa tricks hai ki kam karte karte jaisa problem aya bina formula yad rakhe kar pau
Rather than making table one by one.........we can use macro
Sir pls provide practice sheet
Can you share link for website.I searched it its not opening
With the help of AI bhi btaiye , how to work in excel with the help of chat gpt
What is ur website name
Sir factory ma football banay jaty hai on ko computer par scane kar KY bad ma btana Hota hai kis ny kitny football banay hai asi koi video hai tu plz link send kar dy 🙏🙏🙏
Ya Kam mil Raha ha magar itna knowledge nai hai plz guide 🙏🙏🙏
Sir switch formula is not able to accept in my pc please need help
Switch ki jgh indirect function?
Sir worksheet de dete toh practice ho jaati
Khud bhi bana skta hai.... Vo to tu bhai, it' easy
Sir practice file link share kr diya kro please 🙏🙏🙏🙏🙏🙏
Sar KIS app per padhaate Ho
Bina practice file ke ye video hamare kis kam ka???
Sir why my all columns automatic change in formula..how to delete this formula in vlookup.and my laptop.
how can i download the data sheet?
practice file
Sir G training file bhi diya kro
sahi kaha brother 👍
Itna to khood hi bana sakte h😂
Koi video h to please link
Are sir. Excle me to switch function aahi nhi rhaa
SWITCH FUNCTION WORK NI KR RAHA HAI BROO
Bhai agar name se hi pura data nikalna he to kese kre
Mera Switch function Kam nehi kar Raha hai 2016 me
not working on switch on validation
Sir resume wale video me apne 0.5 margin lene ko kaha jab border me colour krre hai to wo bahar jara h plzz tell kya hua h
Nerro mergin kar liya karo page setup k group se.
sir practice file do
Switch formula hi Nahi hain excel main
Sir video ti thik hai lekin aap file diya kro
Ye bekar ka function use karke time waste mat Karo is case main sidha table ka name hi change karde for ex- Yr2021,Yr2022 then use it as vlookup table name 🦄🧐
0:17 as an excel not a BTW 😊😅
😂😂😂😂😂😂😂dimag ka dahi kar diya bhai, Excel aasan banana hai
Muskil nahi 😂
Lol use curly braces for references it is one at a go
Sir agar 4 sheet ka data hai aur us subhi data ko 1 hi sheet mai merge krna hai toh wo kaise kre vstack ka use krte hai but samgh ni aya pls jaldi video bna ke dale hamara interview hone wala hai
Thank You Sir