Apse maine sikha hai interview dete rehna chahiye nai to mein hamesha sochti pehli interview mein selected ho jau lekin apka vedio dekhne ke bad mein bht sari jagah interview dia or selected hui kahi rejected hui lekin maine waha apni galti se sikha or uspe kam kar rai hu or mjhe bht acha lag raha hai mein kuch naya sikh rai hu .Thank u sir ☺️
sir, you are really doing a great job. thank you for providing us these kind of knowledge.i found your channel in random search and i wonder why there is so less likes on your videos according to your great work and efforts. i don't know how much subscribers you have, but i wish for the tremendious growth of your channel😊🙏
Oh dear these words really mean a lot to me but I think subscriber count doesnt matter to me yes that's true cause everyday I am getting your lovely comments about how my videos have made a change in your life and that is the most amazing feeling . I will surely cover such things in a qna video some day 🙂🙏 till then keep Supporrting me
Thank you so much sir I always wait for your videos. Such a wonderful video. It helps more to us. I need such kind of videos, Please keep trying to make such kind of videos...
This is what I expect Altaf ..Good job..koi nhi rok skta interview clear hone se ydi aap mis interview cracker series khudse attempt kar pa rahe hain to
@@Innozant ha sir 95% tak questions khud se kar pa rahe.....abhi mai 11th mein hu sir ....aur tally sikh rahe......ms excel toh mera sabse favourite hai hamesha se ....❤️
Ur teaching is very clear sir.. I am beginner to excel.. Can you upload d video about weekly, monthly, n yearly reporting in MIS.. I am curious to know.. Plse sir
Thanks Archana to start watching my video and learn from there , Recommend you to start learning step by step from Playlist-BASIC EXCEL as m going to upload class video there in sequence,Still facing issue you may feel free to discuss your query with me.
Just need to understand if in the raw data, client name is inconsistent as extracted from multiple source. In some cases it's not matching due to space issue i.e missing space from first and second word. Let me know how to deal with such issue.
Sir, In Q3 Index Formula, I tried out one other approach. Please have a look once! IFERROR(INDEX(IF($A$5:$A$15 = "P", $C$5:$C$15, " "),MATCH(G6,$B$5:$B$15,0))," ") Jese aapne bataya tha, jo value humko chahiye.. vo index mei lo.. toh mene wesa hi kiya bas wahape If ka formula jod diya.. Aur last mei "value error" aa raha tha.. coz wahape P nahi A tha.. So usko hatane ke liye IFERROR formula laga diya...
Sir ,my question may be silly but take it as a student doubt. Every Excel trick is found on internet now, then why there are interviews for excel based work and why can't they take without knowledge test of excel?
Its not silly questions frok you dear..your dought is genuine..Excel Skills Is one part ..interviewer is also know about candidates other skillset..His presentation skills .. communication skills..technical and other criteria they need to map
Sir, I want to know that for getting a good job good command on advance Excel is enough or we should also learn Vba? Or we can only have a job by learning advance Excel+ Vba. Is VBA must with advance Excel? I am very much confused. Please guide. Thank you.
Offcourse it's enough to start your career in MIS Field ,Yes VBA and SQL is required but it not necessary that without VBA and SQL there is no job or very low profile..You may view my video in detail..Why MIS.Job oriented. ruclips.net/video/Z-ElRbzWL2I/видео.html
sir mail id wale que. me text column karke jaldi or aasani se ans. nikal sakte the agar flash fill nhi tha excel version me. toh q complicated formula ka use kiya. matlab ans. nikalne se he ya complicated tarike se ans. nikal se. or 2nd que me again do chhote formula vlookup or index lagake ans. nikal sakte the. again complicated formula ka use kiya aapne. or expert level que. me achanak sumif q puchha unhone. me aapke knowledge ko nhi challenge kar raha wo aapki mujhse kahi jyada he. just mujhe laga toh mene bataya aapko
Vishal ji awp bukul.sahi leh rahe hain ki text to column use kar sakte the..ye baat to mere mind me bhi aaya hoga na..lekin aapko bata du ki jab kisi dhange ke organisation me jayenge interview dene to wahan wo flash fill aur text to column disable rakhte hain matlab saaf hainki wo formula application ki umeed aapse karte hain.😀 2sre ques ka solutions vlookup se hi kyu index aur indirect se bhi kiya ja sakta hai but aapne dhyanse yadi interview cracker dekhte hain to main wahan apna solutions nhi aap logon ka hi solution ho aap attempt karte hain interview dete time..aapna experience aur questions share krte hain whi qyes interview cracker me karaya jata hai jo interview deke aaya hai unhika attempt. Rahi baat third ques ki to unexpected questions kiye jaate h interview dene ke dauraan..sumifs ka ques ek common ques hai dear pucha ja skta hai. Aapse gujarish h pehow concept seekhne ke baad interview cracker seriea jaroor attempt kren..basic to adv level ke ques mileng aur aapka confidence bhi badhega..❤️❤️❤️🙏🙏🙏🙏
Sir kya main ise aise bhi ker skta hoon maine pehle video pause kerke aise hi output nikaala thaa plzz reply sir plzzz IF($A$43:$A$54="P",INDEX($C$43:$C$54,MATCH($F43,$B$43:$B$54,0)),"")
Question asked in my interview is:- Suppose we have to calculate employee incentive , condition is such that , between 80% to 100% only 1% incentive will be given, and on achieving 100% , 3% incentive will be provided. But above 100% traget , 0.25% incetive will be given on every Rs5000. Kindly help me , how i can calculate ???
Use simple nested if ,Ifs or most easy is using vlookup,if your concept is clear of these topic it's easy question ,You may learn nested if concept through the video provided in Basic Excel playlist else you may share your worksheet on innozantcampus@gmail.com ,Will solve it and revert back to you.
Bilkul sahi bola hai Nasim sahab..Jo gyan aap de rahe hain Flash Fill ka Wo Excel ke liye bachon wala khilona hai dear😀Aur is khilone se khelne ko mai kabhi nhi kehta hu kyunki ye aapaahij banata hai skils ko.. Aap ek kaam kariye flash fil apply krke output lane ke baad source data ko change kriye ..output change hua? Formula ki jagah koi le hi nahi sakta .. interview dene jana aur aise hi flash fill use krke ek second me output nikal dena..wo bhi ek second me gate ke bahar ka rasta dikha dega😀😀 Na andher nagri hai na chaupat raja hai..Ye learner ke upar depend krta hai..Malik.🙏 Humne to jaise kabhi flash fill ka naam hi nhi suna hai Parvez sahab❤️😀😀😀
Sir pata Nahi ek comment Apko dikhega ya Nahi kyuki bahut sare notification Apko RUclips par aate honge isliye is comment ko mai thode jyada baar Likh raha hun. Q2 ko aap sumproduct se solve Karke upload kijiye ya fir solve Karke email par solution send kijiye. 🙏🙏
NO, 2 way lookup is fine but we need to check attendance as well for P or A thats why If is mandatory to check the attendance status.You may try to implement using index match match with if one time only even it is more optimized.
hello sir how are you me apki video roj dekh raha hu. mujhe apka explaination acha laga but sir ye bataiye mujhe mis executive profile ke technical ineterview crack karna ho aur mera jo mis experience nahi hai only i know about vlookup, hlookup and pivot table toh muje guide kijiye ki three days me interview hai mera toh muje interview crack karne ke liye kya study karni chahiye jise me easily crack kar pau interview. lease sir
Itne jaldi Interview schedule hai koi baat nhi..Give your 💯 percent,Statistical function (Countifs series ,Rank, Frequency ) ye sab ek baar revise kar lijiye Question aayega isse ,Saath hi double Vlookup ,Duplicate vlookup, thore bht index match if possible ki practice kar lijiye,Selection ho ya na ho interview kaise bhi arrange ho dena hai..ok..Kuch seekhenge hi..aur aap apna skills alreday improve karne me lage hi hain..Best of luck
Good Morning Arti, -1 isliye kyunki humen jo text extract krke leke aana hai wo space tak aaye ye ek character pegle tak?thats why -1 ,aap debug krke dekhiye select and f9 press karke.Samajh ke apply karna hai formula ,Nahin aye kuch samajh to aap connect kar sakte h mujhse via telegram or Zoom or you may call me for the same.🙏❤️🙂
Apse maine sikha hai interview dete rehna chahiye nai to mein hamesha sochti pehli interview mein selected ho jau lekin apka vedio dekhne ke bad mein bht sari jagah interview dia or selected hui kahi rejected hui lekin maine waha apni galti se sikha or uspe kam kar rai hu or mjhe bht acha lag raha hai mein kuch naya sikh rai hu .Thank u sir ☺️
Wow...This is what I expect Sonali..
Never quit ..Keep learning ..God bless you
Have a wonderful career ahead.
You are very very down to earth person....superb quality you have
Thanks Manish Ji.Really means anlot to me
These Interviews Series Are Simply The Best. 🔥🔥🔥
Thanks Pawan❤❤
The way you teaches is really great sir, I am greatful to you sir, please dont ever stop teaching us, sir, pranam
Thanks Deepak ji..Happy learnibg dear❤
sir, you are really doing a great job.
thank you for providing us these kind of knowledge.i found your channel in random search and i wonder why there is so less likes on your videos according to your great work and efforts.
i don't know how much subscribers you have, but i wish for the tremendious growth of your channel😊🙏
Oh dear these words really mean a lot to me but I think subscriber count doesnt matter to me yes that's true cause everyday I am getting your lovely comments about how my videos have made a change in your life and that is the most amazing feeling . I will surely cover such things in a qna video some day 🙂🙏 till then keep Supporrting me
बहुत अच्छा लिखी हो
Such an amazing video you are making for us sir tq you for all these🙏🙏🙏🙏
Right say @ishutiwari
Yes dear you're right 👍
the way you explain the topics is amazing...We all need to support such you tube channels
Love you Shashank Ji❤️❤️🙏Really means a lot to me . thanks for your love and support dear 🙏
Just subscribed this beautiful channel... Really hats off for sharing this much of knowledge to every one. Please continue and God bless you. 🙏🙏🙏
Thanks..God bless You.. Really means a lot to me ❤️
Sir aap to sab ka kaam aasan kardiya hai, I am really feeling proud to watch your vd's
Thanks dear❤️👍
Thank you so much sir I always wait for your videos. Such a wonderful video. It helps more to us. I need such kind of videos, Please keep trying to make such kind of videos...
Thanks Anoop,Yes sure will always try to make videos that helps you ,Hope you learn from there,Hv a wonderful career ahead.
Sir, you're so talented ,aapko itni knowledge h excel ki fir bhi aapko job nhi Mili ab tk .
🤣🤣🤣🤣Thanks Bhawna,Chalo aapne ye aaj yakeen dilaya ki mujhe acting bhi aati hai..Thanks Keep watching and learning.Main aaplogon ke liye humesha interview aise hi deta rahunga.🤣🤣
I got it , sir 😃
@@Innozant 🤣
Thank u so much sir.....mai aapke kai basic video ke kaaran inn advance questions ka bhi answer khud se solve kar pa raha hu 😍
This is what I expect Altaf ..Good job..koi nhi rok skta interview clear hone se ydi aap mis interview cracker series khudse attempt kar pa rahe hain to
@@Innozant ha sir 95% tak questions khud se kar pa rahe.....abhi mai 11th mein hu sir ....aur tally sikh rahe......ms excel toh mera sabse favourite hai hamesha se
....❤️
Ur teaching is very clear sir.. I am beginner to excel.. Can you upload d video about weekly, monthly, n yearly reporting in MIS.. I am curious to know.. Plse sir
Thanks Archana to start watching my video and learn from there , Recommend you to start learning step by step from Playlist-BASIC EXCEL as m going to upload class video there in sequence,Still facing issue you may feel free to discuss your query with me.
Sir very very helpful video. Sir aapko saari videos achi hoti hai ki agar koi aapki video dekhkar padna chahe to araam se pad sakta hai
Thanks Binni..Hope it helps
Sir your videos are amazing, we need more and more videos on excel and SQL interview questions. Thank u..
Thanks Preethi...Happy learning ❤️,Sure dear will make more quality content for you
@@Innozant Sir can u post data analyst interview questions?? and what are the actual skills required for an entry level data analyst role?
Sir date column values decimal format me rehti h toh, usse date format dd.mm.yy format me kaise convert karte hein???
Thanks a lot sir for making that kind of wonderful videos which enhance more confidence to move on next level of job.
Thanks dear for wonderful comment,Hope you learn from there and. Enhance your skills.
thanks sir for giving this precious lesson 😇
Thanks Mayank ji.Happy Learning ♥️
I have no word for you sir question is no difficult bcz your teaching way is wow
Thank You Vijay jl for lovely appreciation dear🙏❤
यह गलती तो हम ने भी की थी सर. Thank you. अच्छी बाते शेअर करते है आप.
Aaage nhi karenge ..ye yaad rakhen
Just need to understand if in the raw data, client name is inconsistent as extracted from multiple source. In some cases it's not matching due to space issue i.e missing space from first and second word. Let me know how to deal with such issue.
These experiences videos r 2 beneficial sir
Your way of teaching is very awesome i love every time watch your videos 🎉🎉
Thanks Manish Ji.Really means a lot to me .God bless You
Hi . Is there any other concise approach for questions 2 and 3
Sir please keep on posting new videos, really appreciate your efforts.
Thanks Narender Ji❤
You are best teacher in youtube
Thanks Arjun for such a wonderful appreciation dear..It really mean a lot to me.God bless you.🙏❤️🙂
Thank you sir for such really good learning video for interview 🙏🙏
Thanks Sneha..We welcome you to experience the taste of success with Innozant -Seed of Success ❤️🙏
@innozantofficial telegram id for query support 👍
yes
You are doing a very good job sir please keep it up..😊
Great sir what a video its really helpfull for fresher
Thanks Khan sahab❤️
Welldone sir
Thanks Nisha Ji❤️
Sir i want to take your class, you are awesome and great teaching style God bless you
You may contact us for live interactive session.For more infor visit Innozant website
Sir,
In Q3 Index Formula, I tried out one other approach. Please have a look once!
IFERROR(INDEX(IF($A$5:$A$15 = "P", $C$5:$C$15, " "),MATCH(G6,$B$5:$B$15,0))," ")
Jese aapne bataya tha, jo value humko chahiye.. vo index mei lo..
toh mene wesa hi kiya bas wahape If ka formula jod diya..
Aur last mei "value error" aa raha tha.. coz wahape P nahi A tha.. So usko hatane ke liye IFERROR formula laga diya...
Sir ,my question may be silly but take it as a student doubt.
Every Excel trick is found on internet now, then why there are interviews for excel based work and why can't they take without knowledge test of excel?
Its not silly questions frok you dear..your dought is genuine..Excel Skills Is one part ..interviewer is also know about candidates other skillset..His presentation skills .. communication skills..technical and other criteria they need to map
I don't understand question number 2
. Could you please explain it in more detail?
First name and last name can be extracted by using Text to columns.
Your teaching power is great
Thanks Paresh Ji,Keep watching ,Learn and enhance your skills.
Find is case sensitive
In this case u can use search also that is not case sensitive
👍❤️
Always waiting for your video . This one very helpful and informative.
Thanks Sachin,Hope it helps ,Keep learning
Really nice 👍 plz keep it up with new video
Thanks Komal ❤️👍
GURU JI PRANAM 🙏
You are the best... ❤️
Thanks Gaurav Ji
Just clicked on gdrive link and wait! Sir has given bunch of assignment for free!! Thank you so much @innozant
You are a master at this.
❤️🙏
Sir, I want to know that for getting a good job good command on advance Excel is enough or we should also learn Vba? Or we can only have a job by learning advance Excel+ Vba. Is VBA must with advance Excel? I am very much confused. Please guide.
Thank you.
Offcourse it's enough to start your career in MIS Field ,Yes VBA and SQL is required but it not necessary that without VBA and SQL there is no job or very low profile..You may view my video in detail..Why MIS.Job oriented.
ruclips.net/video/Z-ElRbzWL2I/видео.html
@@Innozant Thanks a lot Sir for your precious guidance and thank you for the valuable link.
Wah sir iam become your big fan
Thanks Danish sahab.
Happy Learning.❤️
Very Nice Sir
Thanks dear ❤
Best👍💯👍💯
Very useful tips for interview.. great sir
Thank You Aishwarya for valuable feedback,Never Stop Learning.
Superb Sir
sir mail id wale que. me text column karke jaldi or aasani se ans. nikal sakte the agar flash fill nhi tha excel version me. toh q complicated formula ka use kiya. matlab ans. nikalne se he ya complicated tarike se ans. nikal se. or 2nd que me again do chhote formula vlookup or index lagake ans. nikal sakte the. again complicated formula ka use kiya aapne. or expert level que. me achanak sumif q puchha unhone. me aapke knowledge ko nhi challenge kar raha wo aapki mujhse kahi jyada he. just mujhe laga toh mene bataya aapko
Vishal ji awp bukul.sahi leh rahe hain ki text to column use kar sakte the..ye baat to mere mind me bhi aaya hoga na..lekin aapko bata du ki jab kisi dhange ke organisation me jayenge interview dene to wahan wo flash fill aur text to column disable rakhte hain matlab saaf hainki wo formula application ki umeed aapse karte hain.😀
2sre ques ka solutions vlookup se hi kyu index aur indirect se bhi kiya ja sakta hai but aapne dhyanse yadi interview cracker dekhte hain to main wahan apna solutions nhi aap logon ka hi solution ho aap attempt karte hain interview dete time..aapna experience aur questions share krte hain whi qyes interview cracker me karaya jata hai jo interview deke aaya hai unhika attempt.
Rahi baat third ques ki to unexpected questions kiye jaate h interview dene ke dauraan..sumifs ka ques ek common ques hai dear pucha ja skta hai.
Aapse gujarish h pehow concept seekhne ke baad interview cracker seriea jaroor attempt kren..basic to adv level ke ques mileng aur aapka confidence bhi badhega..❤️❤️❤️🙏🙏🙏🙏
@@Innozant ok sir thanku
Me bhi yahi kartaa hun.....
Benefit........i m fearless...😀🙏
Good .👍❤️🙏
@@Innozant Thanks dost...🙏👍
Very good sir👍🔥👌
Sir kya main ise aise bhi ker skta hoon maine pehle video pause kerke aise hi output nikaala thaa plzz reply sir plzzz
IF($A$43:$A$54="P",INDEX($C$43:$C$54,MATCH($F43,$B$43:$B$54,0)),"")
Very good video sir
Thanks Mohammad Sadiq
waahh guruji waaahh
Really Impressive Sir
Like to dil se automatically hota h sir
Thanks
Respect by Heart
I HAVE TO SORT DATA USING FORMULA IN EXCEL 2007. THE SORTING SHOULD BE MORE THAN ONE LEVEL . HOW IS IT POSSIBLE
sir, we can easily use flash fill in the cell after entering first name
But interviewer want formula based solution not using flash fill
Question asked in my interview is:- Suppose we have to calculate employee incentive , condition is such that , between 80% to 100% only 1% incentive will be given, and on achieving 100% , 3% incentive will be provided. But above 100% traget , 0.25% incetive will be given on every Rs5000. Kindly help me , how i can calculate ???
Use simple nested if ,Ifs or most easy is using vlookup,if your concept is clear of these topic it's easy question ,You may learn nested if concept through the video provided in Basic Excel playlist else you may share your worksheet on innozantcampus@gmail.com ,Will solve it and revert back to you.
Thanku sir. Very informative.. sir plz solve question no.2 using index function. It would be very helpful..
Sir, mera corresponding wale ma enter krna per ....false dekh rha
Very useful vedio
Seriously u are great sir
Thank you Bhoopendra,Watch Full video and learn from there step by step.
Sir ye first name n last name mein ... flash fill ka use karke bhi answer find out kr skte h Naa?
Haan kar sakte hain but formula hi interview me puchega ...😊👍
Very interesting series.
Thanks Gulshan ji
Excellent Bhai.. 💕😍😍
Thabks Sridhar ji
andheri nagari choupat raja... Sorry CC Bro, magar aapke 1.Q k liy sabse aasani se hojata oh bhi 3secsonds me agar aapne Flash Fill se kiya hota to
Bilkul sahi bola hai Nasim sahab..Jo gyan aap de rahe hain Flash Fill ka Wo Excel ke liye bachon wala khilona hai dear😀Aur is khilone se khelne ko mai kabhi nhi kehta hu kyunki ye aapaahij banata hai skils ko..
Aap ek kaam kariye flash fil apply krke output lane ke baad source data ko change kriye ..output change hua?
Formula ki jagah koi le hi nahi sakta .. interview dene jana aur aise hi flash fill use krke ek second me output nikal dena..wo bhi ek second me gate ke bahar ka rasta dikha dega😀😀
Na andher nagri hai na chaupat raja hai..Ye learner ke upar depend krta hai..Malik.🙏
Humne to jaise kabhi flash fill ka naam hi nhi suna hai Parvez sahab❤️😀😀😀
In third question we can use filter then we easily trace subject
Ok Pradeep Ji..try Kiya kijiye alag alag method se Questions ko attempt krne ka .👍👍♥️
👌very nice way to explain
Thanks Ravi Sahab..Happy Learning 🙏❤️
Great Man! Thanks
Thanks Singh Saab❤️🙏
Sir... U are really good like...
Like GOD.. You are Adorable...
❤🙏🙏
Grade sir
Sir pata Nahi ek comment Apko dikhega ya Nahi kyuki bahut sare notification Apko RUclips par aate honge isliye is comment ko mai thode jyada baar Likh raha hun.
Q2 ko aap sumproduct se solve Karke upload kijiye ya fir solve Karke email par solution send kijiye.
🙏🙏
Sir two cell ke text ko yak cell ke text me kysa kare ge
Sir please Q.2 ko thode acha se explainn karenge aap last me samjh nhi aaya thoda
Sir direct Power query se add column ka use kar ke nahi kar sakte kya pls reply
Haan kyu nhi
Nice sir
Just asking can we use flash fill to extract first or last name from email id
Why not...flash fill requires data pattern
Sir first question can also be done by using flash fill function simply?
Hahaha..Flash fill se interview me bhi answer denge ?
@@Innozant yes! Shouldn't I?
Sir Dil khush kar diya apne
Good Morninh Dear,Dil to apke is pyare se feedback se khush hota h mera..air din ban jata h
🙏♥️🙂
@@Innozant video m aapka Question 2 nhi aa rha smjh m?
You are great sir
Thanks Ram,Keep watching ,Learn in depth , enhance your skills and move ahead . Wishing you great career Ahead.
sir flash fill se bhi hota 😊
Usse hi karna hota phir itna mehnat hi kyu
Good
👍👍♥️🙏
Thank you very much 🙏🙏🙏
Thanks Samat🙏❤️
sir, if i want to extract '.com' from all the names.....then what will be the formula?
Find .com and extract the same
Is this company interview questions or self made questions for practice?
Therse are interview questions collected from various interviews.keep learning
@@Innozant thank you sir ❤️
great sir
Thanks Deeapak ji❤🙏
Thanks sir..
♥️🙏
Thank you sir
Thanks Meenu,Keep Watching ,Learn and Share.
If we use only one time index and match with if condition for question no 3, will that make any difference??
NO, 2 way lookup is fine but we need to check attendance as well for P or A thats why If is mandatory to check the attendance status.You may try to implement using index match match with if one time only even it is more optimized.
@@Innozant I did this way.
If(A1="p",index(match),"")
Good..
👍👍👍
Good nice I also thinking same
Thanks Negi Sahab,Hope apne is Interview video se kuch jaroor seekha hoga.
Yes but I am working in different domain but like your teaching skills😍😍
Excel will be applicable everywhere so it is good to learn new things.
Sir , i do have a question for you.
C:\Users\DESK01\Desktop\Excel Class\Dummy Data.csv
Find Folder Name & File name
File name dumt data and other to it are folder.
@@lingarajswain5591 yeah, I know that, but we have to solve it with Excel formula.
@@himanshupandey-cx1cw oh.. hy
Sir question bhut hard hai
hello sir how are you me apki video roj dekh raha hu. mujhe apka explaination acha laga but sir ye bataiye mujhe mis executive profile ke technical ineterview crack karna ho aur mera jo mis experience nahi hai only i know about vlookup, hlookup and pivot table toh muje guide kijiye ki three days me interview hai mera toh muje interview crack karne ke liye kya study karni chahiye jise me easily crack kar pau interview. lease sir
Itne jaldi Interview schedule hai koi baat nhi..Give your 💯 percent,Statistical function (Countifs series ,Rank, Frequency ) ye sab ek baar revise kar lijiye Question aayega isse ,Saath hi double Vlookup ,Duplicate vlookup, thore bht index match if possible ki practice kar lijiye,Selection ho ya na ho interview kaise bhi arrange ho dena hai..ok..Kuch seekhenge hi..aur aap apna skills alreday improve karne me lage hi hain..Best of luck
=IF(A4="P",INDEX($C$4:$C$14,MATCH(G4,$B$4:$B$14,0)),"") SIR YE FORMULA OPTIMISE KIA OR SAME RESULT AYA
👍
sir interview call not coming if there is any consultant number plzz given the number in comment box . because i need a job 🙏🙏🙏
Sir, tell me please why did you minus 1in last of mid formula
Good Morning Arti, -1 isliye kyunki humen jo text extract krke leke aana hai wo space tak aaye ye ek character pegle tak?thats why -1 ,aap debug krke dekhiye select and f9 press karke.Samajh ke apply karna hai formula ,Nahin aye kuch samajh to aap connect kar sakte h mujhse via telegram or Zoom or you may call me for the same.🙏❤️🙂
Sir kya ye Wild card find and replace se nahi ho sakta
Kaunsa Question?? ❤️🙏
Sir yahi video wala
Sr apki vedio bina dekhe he like kr deta hu me to
Thanks Virendra For wonderful feedback,It's my pleasure dear.
Can we use Flash fill..in 1st question ?
Kar sakte hain.bug formula use Kiya kijiye kyunki interview me nhi use krne dega flash fill
Hi sir, mera ek query dha,apka sath kaise excel file share karu ???
innozantcampus@gmail.com