When the notification blinks, I just feel my favourite Sir is taking me one step forward towards the success. I can't explain sir, how much your lessons help the students like me. Great Inspiration.
Your way to teach is ULTIMATE. It helped me the most when required. Please also start VBA series as it the most important and useful part of automating the tasks in this era.
@@Innozant Thanks for the update and great to see your reply within 24 hours of comment. Only dedicated & focused people can do this. WISH YOU ALL THE VERY BEST!
Sir apka pivot table ka video bohot Acha laga bohot kuch Sikh payi hu agar pivot chart ka kuch video banayenge to bohot Acha lage ga woha chart kabhi kuch sikh payenge
Sir aapnai aaj new concept shikhaya. Aapsai acha teacher koi nahi. You are very unique. Your teaching so different. Aapkai teaching ka bahut hi acha style hai. Har step ko achai sai decribe kartai ho aap. Kaha par kya hoga. Thank you so much sir 🌠🌠🌠🌠🌠🌷
Sir you are such a fabulous teacher. Everyone can explain but your method of teaching & explaining is best & better. A child can easily catch. Thanks for your great effort... Sir can you please explain how to find 3 & 4 Product as well. & one more thing before Match function and after & you add bracket "(" why?? I think its for Indirect but if you will explain its better.. Thanks.
Humko +2 kar k skip nhe karna, large data set pe to ye solution applicable hi nhe hoga, agar deeksha agarwal 4 times ajaye start mn hi, to kia +3, +4 karte rahenge formula mn?? Bina +sign k batayen.
Hi sir, you r explaining all formulas very enthusiastically,👍 i want to learn vba macros basic to advance level from you... If any videos made by you please share link ...
🙏♥️👍 Thanks dear.VBA series not started yet ,After finishing excel will start Power Series-Power Query ,Power Pivot ,Power BI followed by VBA and other associated technologies.Have patience ..🙂🙏♥️
9:29 sir apne yha pe manually +2 kiya match function ke bad. dynamic to ab bhi nhi hua formula. agr "diksha aggarwal" 2 se jyada bar repeat ho aur 3rd order ya 4th order...nth order wali "deeksha aggarwal" ka answer chahiye hoto to formula me bar bar match ke bad jo plus krna h uski value change krni hogi manually. mene iska bhi solution find krne ka try kiya but nhi hora. agr apko kuch solution mile to plz btana sir.🙏
Ye dynamic nhi vlookup second match Question tha Ishu,Haan nth match bhi Kara sakte hain as per requirement,Aapne kya socha Uske liye btaiye..main help karte hu dynamic bnane me
@@Innozant mera bs yhi question h ki agr deeksha aggargar 1 se jyada bar repeat ho aur agr 3rd position wali deeksha aggarwal ka output lana ho bina match ke bad kuch manually plus kiye to kese laye.i mean koi data validation se list bnake jisme 1 to nth number tk list ho aur jo number us list se select kre us position wali diksha aggarwal ka output aa jaye to use dynamically kis formula se krenge.formula me manually kuch change nhi krna jese apne video me +2 kiya tha match ke bad.if possible,then please reply🙏
Haan to manually add krne ke jagah Jo data validation list liiya hai Uske liye match Chala lijiye wo us relative position Ka text extract krke le aayega
@@Innozant sir usse bhi nhi ho payega. mera mtlb ye tha ki ek cell me names hone chahiye jese apne is question me kiya hua h aur uske sath wale cell me only numbers ki list.list bnana jrori nhi h.kisi cell me bs numbers bhi likh skte h. jese ek cell me deeksha and doosre cell me 1,2 ,3 or nth number.aur vo formula usi number vale position ki deeksha ka output laye. ye match se possible kese h?🤔match hi lgana h to helper column lena hoga.mujhe bina helper column ka answer chahiye.it's ok sir,i know bhut mushkil h ye.bina helper column ke maybe possible nhi.
@@Innozant sir Thanks for your reply lekin jaise man lete hai field ki employees ke expense report bana rakhi employee code wise, usme se ek code ki sabhi entry nikalni h vlookup se Like filter ki tarah lekin vlookup se
Sir excel main koi aisa tareeqa ha jis say hum data match kar skay Examaple K aik Vichel ha woh City A 1 apr ko 23:00 bajay aayi Or or City 2 3 apr ko 10:00 bajy phonchi Tu mahinay main kitnay trip kiye or Is vichel ki journey deatil kesay find out ho gi q k vichel ka number nahi balkay us ki date say find out ho or second main Product qty say maloom ho Kia aisa posibal ha
Index(columnb,small(if(columna=given value,row(a)-row(a)+1),rows($a:a))) Since here we need the second value we can type 2 instead of the rows function.
Sir I want to learn excel from you. From Very basic. I have also done advance excel course but I could not understand anything. Please tell me what should I do to learn from you. I want to become a data analyst. please give proper guidance.
ok 2nd product ke liye indirect chalaye, multiple product ke liye tho phir HELPER kohi lena padegana.aur detail me multiple products, and huge number of customers mamually tho nahi kar sakte. customers and products automatically identify kiss farmula se karna plz. batao.
Sir, First of all I am very thankful to you. I would like to say this I applied the formula for Second Match but if I have the data in which I want the first match in a cell and then Second Match in succeeding cell and third match in further succeeding cell and so on....then what would be the formula or Logic. Customer Name Deeksha Aggarwal Lemons Apples Strabery .....So On
Sir is formula mein plus 3 karke 3rd order bhi check kar sakte hain? teesra duplicate dhoondne ke liye ? VLOOKUP(F2,INDIRECT("$A$"&(MATCH(F2,$A$2:$A$17,0)+3)&":$B17"),2,0)
Sir, Pls help in building formula to find nth value from a repeated list through vlookup and indirect...This video is only applicable upto 2nd look value
Zoom to rehta hai..ok aur zoom Kar Diya karunga aage se..Juda krta hu zoom to student ke comment aate Hain ki sir mobile me jyada zoom me dekkkat Hoti hai..koi nhi aage se dhyan rakhunga main..than for suggestions ❤️🙂🙏👍
Hi Sujatha ,Third match or nth match ke liye Thora sa aap sochiye ki Jo value hum manually pass Kar rhe Hain wahak match use krke ya Kuch aur method se value pass Kar payen to..🙂 Aap rethink krke is formula ko aur update krke mujhe bataiye nhi to vlookup nth value match Ka video bht jald leke hair HOTA hu dear 🙏♥️
dil se sir apke jaisa UA-cam par nahi hai excel padhane wale
Thanks dear ..keep learning
When the notification blinks, I just feel my favourite Sir is taking me one step forward towards the success.
I can't explain sir, how much your lessons help the students like me.
Great Inspiration.
Love you and truly I feel awesome with this commnent.. Thanks for showny this much love and support.♥️🙏👍
This is beyond excellent sir u r a rare gem in advance excel lot's of things I have learnt from you lots of love to you sir god bless you.😊❤
maja aa gaya bhai, chahe kuchh bhi samaj aaye, na aaye lakin speech badhiya hai 👌
Hahahaha....samajh me bhi aayega dear.
Sequence me Seekhiye concept ko.
Random video nhi dekhiye , playlist start se end Tak dekhen
ये तो बहुत ही गजब Formula सिखाया सर आपने
Thank you
Thanks dear
Your way to teach is ULTIMATE. It helped me the most when required. Please also start VBA series as it the most important and useful part of automating the tasks in this era.
Thanks Ramandeep Ji..Happy Learning dear...Yes I am planming to start Video series.
@@Innozant Thanks for the update and great to see your reply within 24 hours of comment. Only dedicated & focused people can do this. WISH YOU ALL THE VERY BEST!
I WATCHED YOUR EXCEL VIDEO VERY GOOD AND EFFECTIVE
Sir apka pivot table ka video bohot Acha laga bohot kuch Sikh payi hu agar pivot chart ka kuch video banayenge to bohot Acha lage ga woha chart kabhi kuch sikh payenge
Kuch din pahle se aapke video dekha start kiya hai aapke jo samjhane k tarike h o kafi achhe hain🙏
Thanks dear.. Happy learning ❤️
Very interesting and helpfulness
Great teacher
U r such a hardworking teacher...salute ur efforts..excellent explanation sirji
Thanks Ramakant Ji for such a wonderful and valuable feedback . Really Means a lot to me dear.❤️🙏👍
Aapki classes dekh k lgta h ki main interviewer ko kuch naya sikha dunga..
Just kidding. Top content brother. 😄
Haha..ye aap majak nhi sach keh re ho..aap complete series cover kriye..interview questions practice kijiye..ye baat apki sachme sach hogi.. m sure.😀
@@Innozant No doubt bhai. Bas series complete hi hone wali h. Fir MIS interview series dekta hu..
Very happy to see you and also happy learning with you
Thanks Amit ji for this valuable feedback ♥️♥️🙏👍
Am from Pakistan but I love innozant channel ❤
Thanku for the video sir great explaination. good night 😴😴
Thanks Satish Ji.♥️🙏👍gn
Thank you so much sir🙏
Gjb sir Ji 🙏🙏
Thanks ❤️👍🙏
Excellent sir 👍👍👌
🙏❤️👍
Thank you
Very helpful
Sir aapnai aaj new concept shikhaya. Aapsai acha teacher koi nahi. You are very unique. Your teaching so different. Aapkai teaching ka bahut hi acha style hai. Har step ko achai sai decribe kartai ho aap. Kaha par kya hoga. Thank you so much sir 🌠🌠🌠🌠🌠🌷
Thanks Sandeep itna mere mehnat ko appreciate Karne ke liye.God bless you dear♥️🙏👍
Woow sir concept is alag hai thanks for taking my name is table 🙏🙏
Thanks Abhishek Ji ❤️🙏👍
Sir but if the lookup value is repeating more than twice, then to find the 3rd order and so on, this formula won't work! 😔
very excellent sir
Sir you are such a fabulous teacher. Everyone can explain but your method of teaching & explaining is best & better. A child can easily catch. Thanks for your great effort...
Sir can you please explain how to find 3 & 4 Product as well. & one more thing before Match function and after & you add bracket "(" why?? I think its for Indirect but if you will explain its better.. Thanks.
Thanks Jinesh for your valuable appreciation..You mah do the same process foe 3rd or 4th value by increasing match as formula element value.
Humko +2 kar k skip nhe karna, large data set pe to ye solution applicable hi nhe hoga, agar deeksha agarwal 4 times ajaye start mn hi, to kia +3, +4 karte rahenge formula mn??
Bina +sign k batayen.
Nice video sir!Just now I realised my name is on the screen.:)
Thanks Mira❤️❤️👍👍God bless you dear
Very useful thank u sir
Thanks Vishal ji❤️
Hi sir, you r explaining all formulas very enthusiastically,👍 i want to learn vba macros basic to advance level from you... If any videos made by you please share link
...
🙏♥️👍 Thanks dear.VBA series not started yet ,After finishing excel will start Power Series-Power Query ,Power Pivot ,Power BI followed by VBA and other associated technologies.Have patience ..🙂🙏♥️
Superb....
Thanks Mishra Ji for your valuable feedback. Happy Learning ❤️🙏
Nice sir
Thank a lot sir
Thanks Rajeev ji
Great Logic
Thanks 👍🙏❤️
Hello sir, Actually i have to apply same formula for mulitple columns is it possible ??
Bhai may jab apka helper column wala procedure apply krta hoon result NA ata hy?aap help krdygy
Superb
Thanks dear
9:29
sir apne yha pe manually +2 kiya match function ke bad.
dynamic to ab bhi nhi hua formula.
agr "diksha aggarwal" 2 se jyada bar repeat ho aur 3rd order ya 4th order...nth order wali "deeksha aggarwal" ka answer chahiye hoto to formula me bar bar match ke bad jo plus krna h uski value change krni hogi manually.
mene iska bhi solution find krne ka try kiya but nhi hora.
agr apko kuch solution mile to plz btana sir.🙏
Ye dynamic nhi vlookup second match Question tha Ishu,Haan nth match bhi Kara sakte hain as per requirement,Aapne kya socha Uske liye btaiye..main help karte hu dynamic bnane me
@@Innozant
mera bs yhi question h ki agr deeksha aggargar 1 se jyada bar repeat ho aur agr 3rd position wali deeksha aggarwal ka output lana ho bina match ke bad kuch manually plus kiye to kese laye.i mean koi data validation se list bnake jisme 1 to nth number tk list ho aur jo number us list se select kre us position wali diksha aggarwal ka output aa jaye to use dynamically kis formula se krenge.formula me manually kuch change nhi krna jese apne video me +2 kiya tha match ke bad.if possible,then please reply🙏
Haan to manually add krne ke jagah Jo data validation list liiya hai Uske liye match Chala lijiye wo us relative position Ka text extract krke le aayega
@@Innozant sir usse bhi nhi ho payega.
mera mtlb ye tha ki ek cell me names hone chahiye jese apne is question me kiya hua h aur uske sath wale cell me only numbers ki list.list bnana jrori nhi h.kisi cell me bs numbers bhi likh skte h.
jese ek cell me deeksha and doosre cell me 1,2 ,3 or nth number.aur vo formula usi number vale position ki deeksha ka output laye.
ye match se possible kese h?🤔match hi lgana h to helper column lena hoga.mujhe bina helper column ka answer chahiye.it's ok sir,i know bhut mushkil h ye.bina helper column ke maybe possible nhi.
Sir
Agar lookup value ke many match ho to sabhi match nikal sakte h dusri sheet par without helper column
Haan kyu nhi .. vlookup ke saaty indirect uae karke nikaliye..
@@Innozant sir Thanks for your reply lekin jaise man lete hai field ki employees ke expense report bana rakhi employee code wise, usme se ek code ki sabhi entry nikalni h vlookup se
Like filter ki tarah lekin vlookup se
Sir, please bring VBA series soon as it is frequently asked in interviews..
Yes Param,We are planning to start the same
Sir excel main koi aisa tareeqa ha jis say hum data match kar skay
Examaple
K aik Vichel ha woh
City A 1 apr ko 23:00 bajay aayi
Or or City 2 3 apr ko 10:00 bajy phonchi
Tu mahinay main kitnay trip kiye or
Is vichel ki journey deatil kesay find out ho gi q k vichel ka number nahi balkay us ki date say find out ho or second main Product qty say maloom ho
Kia aisa posibal ha
❤️❤️❤️❤️
sir kia ham is ko power query kaay sath ker saktay haay ,,,kis tarah
Index(columnb,small(if(columna=given value,row(a)-row(a)+1),rows($a:a)))
Since here we need the second value we can type 2 instead of the rows function.
loved it
Thanks Ubaidillah Sahab ❤️🙏
Guru gi kindly advise if the number in the a 1:a15 column are same I need to pull out the highest value in the b1:b15 columns please advise
Sir I want to learn excel from you. From Very basic. I have also done advance excel course but I could not understand anything. Please tell me what should I do to learn from you. I want to become a data analyst. please give proper guidance.
Sir,
Column ke time array ki jaigah pe column name ko nehi le kar agar name leta toh kaya formula galat batayega?
Offcourse error btana chaiye column number chaiye hota hai na ap wahan naming range kaise de skte hain?
ok 2nd product ke liye indirect chalaye, multiple product ke liye tho phir HELPER kohi lena padegana.aur detail me multiple products, and huge number of customers mamually tho nahi kar sakte. customers and products automatically identify kiss farmula se karna plz. batao.
Sir, First of all I am very thankful to you. I would like to say this I applied the formula for Second Match but if I have the data in which I want the first match in a cell and then Second Match in succeeding cell and third match in further succeeding cell and so on....then what would be the formula or Logic.
Customer Name Deeksha Aggarwal
Lemons
Apples
Strabery
.....So On
🙏🙏🙏🙏🙏🙏☺️☺️☺️☺️☺️☺️
"Yahin se yahin tak mei usi ko" waala concept ko thada detail mei samjha dijiye sir !
Phirse ek baar dekhiye video
❤️🙏🙏🙏👌👌⭐⭐⭐⭐⭐
🙏❤️👍
jatadhari ji , i did ,to find n number of duplicates without helper coloumns
🔥🔥🔥🔥
🙏❤️♥️👍
But sir, in the 2nd mathod,
how can you decide to skip first row "A", this mathod is wrong to get Answers. It could be more down from "A3" then ? What
Sir mujhe row wise lana hai to kaise karenge..
SIR THIS CONSEPT EXTRACT MAX TO MAX 2 RECORDS HU WHAT IS THE EXTRACT MORE ATHAN RECROEDS
Sir is formula mein plus 3 karke 3rd order bhi check kar sakte hain? teesra duplicate dhoondne ke liye ? VLOOKUP(F2,INDIRECT("$A$"&(MATCH(F2,$A$2:$A$17,0)+3)&":$B17"),2,0)
Haan range se bahar is value ko rakhke kr skte h
@@Innozant ok sir main ek baar phir try karoonga 😀
What if we need to extract third, fourth... Value in vlookup
Sir please make vedio on reverse vlookup with choose,and make it dynamic
Reverse vlookup video is already there ❤️🙏
Sir please make video on how we can use symbols in formula like ..&, () , etc ..
Already explained in no. Of videos dear..kindly learn step by step
But If motive was to skip first two row, why not simply use OFFSET??
⭐⭐⭐⭐⭐
🙏❤️👍
लगता है आपकी मुझसे कोई दुश्मनी है आप मुझे अपना दुश्मन समझते है गुरु जी बाकी हम तो आपसे प्यार करते है 🌹🌹🌹🌹🌹❤
Oho..aisi kya galti humse,
SIR INDIRECT FUNCTION HORIZONTAL KAISE USE KARE THODA BAATAYAEE
HORIZONTAL SUM KAARNE HAIN
😘😘
Thanks Ajay Ji♥️🙏👍
Sir, Pls help in building formula to find nth value from a repeated list through vlookup and indirect...This video is only applicable upto 2nd look value
What output you want?
@@Innozant 3rd lookup, 4th lukup
Sir y table m aapne data validation kyu lgaya h hme isme kya change krna h??
Second match Karna hai dear..aap ek Baar Ques dekhiye
Thanx sir magar agar hamara data sheet ke beech Mai hota to kaise hota sir pls help
Explain kijiye query unable.to understand
@@Innozant sir agar data beech mai se
Matlb h13 se start huva ho aur i 20 pe tak ho....... To kaise hoga. Sir
Good but flop because you have given manual figure 2 in between. It is better to select area manually then not required indirect.
Kindly understand the use and benifit of indirect function as I want desired value without going to that sheet or worksheet
Sir akrim kya hota hai
Sir index se try kiya 2nd value nahi nikal rahaere se kese hoga? Ek kisi vedio main Bata dena plz🙏 ya yahi bata do aap
Ok..Wil try to add it in videos.
Sir. Innozent. At the time of teaching your excel data spread sheet not at zoom level it ahould be zoom so that easily viewers can be understand.
Zoom to rehta hai..ok aur zoom Kar Diya karunga aage se..Juda krta hu zoom to student ke comment aate Hain ki sir mobile me jyada zoom me dekkkat Hoti hai..koi nhi aage se dhyan rakhunga main..than for suggestions ❤️🙂🙏👍
Thanks for prompt respond.
Your tutoriel and teaching is very fine. Stay bless .Regards.
@@Innozant thanks for prompt repond. Teaching style is very fine. Stay bless & take care. Regards.
@@naeemulhassan1426 Thanks Naeemul Sahab..
I didn't get the whole procedure
Query ?
I need vlookup with all match
Hi need help in formula
Duplicate aue Unique ye dono hin bahut dikkat de rahe hai mujhe sir!
1,2,3,4,..... More than vlookup without helper columns =INDEX($A$2:$B$17,SMALL(IF($H2=$A$2:$A$17,ROW($A$2:$A$17)-1,""),I1),2)
Who is Deeksha Agarwal because mostly example this name show in first
She is one of the student like You Amrita❤️.Keep Learning.Keep Exploring
Sir 1 question hai
What about the third match sir?
Hi Sujatha ,Third match or nth match ke liye Thora sa aap sochiye ki Jo value hum manually pass Kar rhe Hain wahak match use krke ya Kuch aur method se value pass Kar payen to..🙂
Aap rethink krke is formula ko aur update krke mujhe bataiye nhi to vlookup nth value match Ka video bht jald leke hair HOTA hu dear 🙏♥️
@@Innozant I think in place of +2, something has to be done. I will try sir.
Very Good Sujatha.Try it and let me know 👍
Ham tusri sheet sath nahi hote ha
Sir samjh nhi aaya
Kya issue
Last mai enter hi nhi mara
Wo Apke liye Chor Diya hai ki ap khudse formula likhenge aur Practice bhi krenge 😀😀❤️❤️🙏🙏👍👍
Tough hai
Hmm.little bit...but do rehearse
Why do you put the title of the video in English and then speak some other language in the video. Click baiters...
It's not click bait dear...This channel is for Hindi Audience only .
But sir same name se 3 4 value ho qki ye question aaya tha abhi interview m
Sir agar 2nd product ke place pe 3rd mange toh kaise karenge