Thanks Sanjay,M really happy for you.These comment really mean a lot to me.Happt Learning and enhance your skills on regular basis.Never stop learing ,No matter eithe you are in job or not.❤️🙏
Thanks Sujata for such a wonderful comment,Aise feedback mujhe aur motivate karta hai ki best deliver karun.Hope aap seekh rahe hain saare video step by step dekhke..aur practice sheet se practice bhi karte hain.Wishinv you a wonderful career ahead.🙏❤️🙂
hi sir, aapne lookup number k example me jo formula likha hain [="Q "&CHOOSE(MONTH(A40),1,1,2,2,2,3,3,3,4,4,4,1)] issme ,(1,1,2,2,2,3,3,3,4,4,4,1) eise kiyu likha hain (1,1,1,2,2,2,3,3,3,4,4,4) eise kiyu nahi
Wonderful... Please make screen smaller don't make it big. It looks like mess... Small screen help us to view the data clearly rather than going to left-right up-down it's make screen unstable.
Aap k vedio dekhta hu to dekhta reh jata hu aisa lagata hai Jese gita main bhagwan krishan ne arjun ko apna gyaan diya waise he aap apne gyaan se hamara marg darshan kar rahe ho guru g itne questions or doubts or aap ek ek kar k solve karte ja rahe ho 😂🙏😊😀
Lots of love for such a lovely feeback..Aise sir par chadhaoge Puran Sahab❤️🙏thanks..Mere liye happiness ye ki apko samjh aata hai aur apke lofe me value add ho raha hain
7:30 sir ye question data validation se list bna ke and fir choose ke sath index number me match function lga ke bhi ho skta h. =CHOOSE(MATCH(B61,E62:E64,0),SUM(B62:B70),AVERAGE(B62:B70),MAX(B62:B70))
Haan match use karke Aapne choose ke index number ko dynamic bana Diya hai..That's good 👍♥️,Aapne improvise Karna start Kar Diya hai ab formula ko ye Acha sign hai.
Sir mai ek interview mai fail ho gya . Question :- ek data h jisme dates h 2014,2015 ki ,sath mai location or sales rep ka column bhi or unka sales amount h . Ab mujhe unka quarterly or monthly or financial year wise data manipulate karwana tha only by using formula not pivot table , Main ye solve nhi kar paaya . Plz mujhe iska solutions batao .
Bhai apka no nhi lag rha hai Mera ek interview tha jisme mai select nhi hua.usme ke kuch questions nhi aa rha hai mughe so mai chahta hu ki aap solve kre jisase bahut logo ki madad ho jayegi.Please reply
Kya esa ho skta h ki jitna number ham ek cell me daale itne hi serial number ho jaye as a like this 10 number daalne par 1 se 10 tk serial number aa jaye..
Information function ke video me.majne bataya hai but aise nhi jo aap puch rahe hain..serial no. Bnana bataaya hai formula ke through,vba se to loop chala ke banana easy hai ..but excel me ek saath populate krna hoga value.
HI SIR
hmne jo v video excel ka dekha other sir ka usme apka bilkul hi alag hota h
thanks sir
Thanks dear God bless You.
After watching your videos I found myself so confident sir.
You just boost my knowledge and confidence.
You are my inspiration sir.
Thanks Sanjay,M really happy for you.These comment really mean a lot to me.Happt Learning and enhance your skills on regular basis.Never stop learing ,No matter eithe you are in job or not.❤️🙏
Wow gajab ka formula, maja aa gaya
Or aage bhi aise hi video dalte Rahiye
Thanks Sir
🌹🌺🌷🌺🥀🌺🌹🌺🌷🌹🥀🌷🌺
Thanks Kundan🙏👍🙂❤️
This is an amazing function which I didn't explored much in day to day work
Sir apka teaching technique ekdam different hai, easily samajh jaate hai. You are a besttttttt teacher. Thanks a lot sir🙏
Thanks Sujata for such a wonderful comment,Aise feedback mujhe aur motivate karta hai ki best deliver karun.Hope aap seekh rahe hain saare video step by step dekhke..aur practice sheet se practice bhi karte hain.Wishinv you a wonderful career ahead.🙏❤️🙂
Wow Sir very beautiful and amazing. Love you sir
Very very interesting Topic🕶🕶.
Thanks for improving my skills
Mja aa gya too good sir...👍👍👍👍👍👍👍👍
Thank you very much sirG
very excellent sir
Sir, you are amazing! ❤😊
Amazing Sir
After watchin this video i m getting confidence
Thanks Aaqib .Happy Learning ❤️🙏
CHOSSE to SUMPRODUCT se bhi kyi guna jyada versatile function lag raha hai sir !! Versatile nahi incredibly versatile sir!!
Abhi aage indirect bhi hai dear😊
Very good and informative video of choose function Sir ji 🙏 you always different and best in explaining anything related to excel. Quality video 🙏🙏
Thanks Harivansh Ji,Happy Learning dear,Hope aap apni skills enhance kar rahe honge aur practice karte honge
@@Innozant bilkul sir apki videos se excel skills 100 percent enhance hote hai or practice bhi karta hoon 🙏🙏
Great Stuff Sir. Incredible. Thank you very much at your tutorial.
Thanks Sandeep.Have a nice day.tc
Thank u sir ji ❤️
Wow great sir ji 👏
Thanks Lokesh.🙏❤️
Thanku for the new concept sir.good night sir
Hope you like and learn Satish ji.Apka dedication.Good.Bina video dekhe aap kbhi nhi sote h..acha kroge life me aap ❤️🙂
@@Innozant are sir aap sharminda kar rahe hai aap video hi aisa banatey hai ki dekhe bina neend nahi aati .
Very nice massage sir
Thanks Manoj ji.hv a great day🙏♥️🙂
Dear Sir, Bahut hi shaandar....🔥❤😍
Thanks Jeetu.🙏🙂❤️
hi sir, aapne lookup number k example me jo formula likha hain [="Q "&CHOOSE(MONTH(A40),1,1,2,2,2,3,3,3,4,4,4,1)] issme ,(1,1,2,2,2,3,3,3,4,4,4,1) eise kiyu likha hain (1,1,1,2,2,2,3,3,3,4,4,4) eise kiyu nahi
Thanks you sir, Choose is really important function.
Yes ..Its is important and easy to use..Will learn in depth about Choose in upcoming videos.👍🙏❤️
Sir amazing.
Thanks dear❤️
Super formula Sir..
Thanks Sandeep Arya Ji.. Happy Diwali to you and your family.🙏❤️
You are great sir explain ek essay kar te ho sir again you are great sir
🙏❤️Happy Learning..Keep aupporting
Sir power query and power pivot ki series complete ho jaaye toh VBA ka complete basic to advanced tutorial bhi bana dijiye ga please please
Will try to upload more videos
Sir Can drag this choose function with formulas in next cell?. If put the value next cell and choose 1 for sum and 2 for sub etc so will it work?
Wonderful... Please make screen smaller don't make it big. It looks like mess... Small screen help us to view the data clearly rather than going to left-right up-down it's make screen unstable.
Thanks for suggestion,As no. Of candidate ask to show big screen as they are using mobile,Ok will make it smaller
I am very thankful to you Sir
Thanks Pramod ji
Thnq sir
Very nice Sir
🙏
Aap k vedio dekhta hu to dekhta reh jata hu aisa lagata hai Jese gita main bhagwan krishan ne arjun ko apna gyaan diya waise he aap apne gyaan se hamara marg darshan kar rahe ho guru g itne questions or doubts or aap ek ek kar k solve karte ja rahe ho 😂🙏😊😀
Lots of love for such a lovely feeback..Aise sir par chadhaoge Puran Sahab❤️🙏thanks..Mere liye happiness ye ki apko samjh aata hai aur apke lofe me value add ho raha hain
Very nice sir g...
Thanks Bhoopendra,Hope aap seekh rae hain..regular
@@Innozant yes sir
Keep it up sir 💪💪
Thanks Shivnarayan.We welcome you to experience the taste of success with Innozant-Seed of success.
Nice sir ji
Thanks Pavan,Hope you are learning step by step on regular basis.
great sir sir offset function KO single Explain kardo please 👍🏻😁
Karan sahab ..offset ka complete tutorial aane wala hai. Dear..bht jald bus choose ,indirect uske baad offset hi to hai..hv patience
@@Innozant OK I am wait sir
✔️🆕 for me.
Thanks sir.
Yes dear,hv a great day🙏♥️🙂
Please compare choose function and Indirect function. There is small confusion between both❤️🇵🇰
ok..Will make video for the same
3:14 4:00 4:36 6:12 8:33
Hi sir isme 4.01 pe. 1,1,2,2,3,3,4,4, kaise or liye hai plz ek explain krte to bhehr hota hai sir..
7:30
sir ye question data validation se list bna ke and fir choose ke sath index number me match function lga ke bhi ho skta h.
=CHOOSE(MATCH(B61,E62:E64,0),SUM(B62:B70),AVERAGE(B62:B70),MAX(B62:B70))
Haan match use karke Aapne choose ke index number ko dynamic bana Diya hai..That's good 👍♥️,Aapne improvise Karna start Kar Diya hai ab formula ko ye Acha sign hai.
@@Innozant
thnku sir g.
ye sb apne hi to sikhaya h.
me to bs apke hi sikhaye hue sare methods, functions combined krke alternative dhudhti rehti hu.🙏😊
This is what I expect from you Ishu.M really happy for you Ishu🙏❤️
Hello Sir, How to contact you for professional training
You may whatsapp/call us on -7065069985
Sir mai ek interview mai fail ho gya .
Question :- ek data h jisme dates h 2014,2015 ki ,sath mai location or sales rep ka column bhi or unka sales amount h . Ab mujhe unka quarterly or monthly or financial year wise data manipulate karwana tha only by using formula not pivot table , Main ye solve nhi kar paaya . Plz mujhe iska solutions batao .
Kyu.nhi kar paaye..excek sheet bnake share kijiye kisi video me add kar dunga question
Okay ..mai exact to nhi bna paunga par thodi similar bnakar bhejta hu .plz reply jaroor karna
Bhai apka no nhi lag rha hai
Mera ek interview tha jisme mai select nhi hua.usme ke kuch questions nhi aa rha hai mughe so mai chahta hu ki aap solve kre jisase bahut logo ki madad ho jayegi.Please reply
Telegram kriye @innozantofficial
@@Innozant okay
Sir yaha pe kuch jagah par #VALUE ! error bata raha ,
Kya esa ho skta h ki jitna number ham ek cell me daale itne hi serial number ho jaye as a like this 10 number daalne par 1 se 10 tk serial number aa jaye..
Information function ke video me.majne bataya hai but aise nhi jo aap puch rahe hain..serial no. Bnana bataaya hai formula ke through,vba se to loop chala ke banana easy hai ..but excel me ek saath populate krna hoga value.
Sir quarter kaise likhna example 2 me plz tell or write Samaj nhi ae
Choose function ke jis index par aap jo value likhna chahte hain likh dein wahi value display me aayega
@@Innozant Thank you sir for clearing doubt
Boss ye choose to confusion hai .. concept clear nhi hva
Oho .ye to aasan hai.recap again👍
Sir Aapka number milskata hai
Vinay Ji aap telegram id - @innozantofficial se Jud sakte hain ya www.innozant.com se contact details le sakte h.
Voice with Vedeo is not matching .. pls have a look
There is no issue dearm.Watch it again.
Nice sir
Thanks Paresh,Learn concept step by step.🙏❤️