Team videos r amazing since ur givinh explation in it difficult understand who doesn't know hindi So try make two versions like one in English and other hindi so that it ll be helpful all audiences irrespective of language. And also try post vidoes technical oral and hr questions how to answer them
Karthik from my perspective hindi audience is my first priority and as more that half of the population understand hindi it can we very helpful for them i am trying to deliver awesome content and trying to make changes in my content to make it more understandable so dont worry there is a lot to come. And you can also check out my excel live interview series there you will find your desired questions and u can practice over them
Sir, Question 4 is not working even after I changed the sheet and made it in a whole new sheet. Same thing is happening, values are not changing according to the drop-down list
Sir , in question number 3, when applying "if" with "small" than it will calculate all the smallest value even if these value are blue or not, suppose if I take red as 5, then calculation that I am getting is different, How this formula can be improved Please reply
At 6:50 the conditional formatting formula is not returning the smallest 3 values, but its showing those rows wherever blue is available. Please let me know how to resolve.
sir kya ye question no 4 choose se kiya jaa sakta hai. i have tried but result is not coming if possible please share the formulas. because u have already said different table me se data uthanke ke choose with vlookpup use kiya jaa sakta hai
sir,Q.no.4 ka automation nhi ho raha hai, whenever i change the player name,details arent changing automatically,i have to do the table array process every time,(edit and ctrl+shift+enter)
Sir, I am using vlookup + choose for the cricketer question but only first row values are extracted, 2nd row values are same as row 1 , no error . Pls advise, I have asked this question in comment below as one of ur user had same issue too. Appreciate your advise Thanks
Sir, question no 4 at 6:57 of this video, when player is selected all the runs should be displayed. I did try offset+ index match and it works fine but I find vlookup + choose easy so I tried that and it works only to get row 1 data but not row 2 onwards, it pulls same data as row 1. Thanks Kavita
Hi sir pdf file se pivot table make kra aapne but ms word open kra phir wha se open with kaise hota h blog dekha smjh aaya sab but word open h to phir open with kese plz ek bar update kre agar aap ke pass tym ho to plz 👍🏻👍🏻👍🏻👍🏻👍🏻
4:29 sir apne is solution me 0-20 range me 0 include and 20 include kiya h. vhi doosri trf apne 20-40 ki range me bhi 20 include and 40 include kiya h. aur again apne 40-60 ki range me bhi 40 include and 60 include kiya h. jbki 20-40 me 20 include nhi hona chhaiye kyoki vo pehle hi 0-20 ki range me aa chuka h . isi trh 40-60 ki range me bhi 40 include nhi hona chaiye kyoki 40, 20-40 ki range me aa chuka h. sir second wale countif me apko "
@@Innozant yes sir,but output same nhi ayega alg alg ayega dono condition me.= lgana hi pdega nhi to ek number ko do bar dono range me consider krega formula.mene check krke dekha h.🙏❤
Statistical advance function and Analysis toolpack series we will start soon .Have patience ,you mag able to see these videos in Innozant channel soon.
previous vdo me id me se name extract kiya tha..or apne right() fun. me bhi len() fun ka use kiya or mujhe smjh hi nhi aaya right or len funtion sir kya kre
Sir mene aapki solve worksheet description se download ki hai in Q.4 me drop down list se name change karne pe score automatic change nahi ho raha hai Isko solution bataye
Your Teaching is excellent. The Only thing I don't like in your video is Hindi. Please put videos in the English language, So, Everyone can understand and you will get more subscribers and Views. Because I don't know Hindi you have all the important content but, I don't understand your language. Thank you and waiting for your videos in English. See These videos don't have that many views and I wanted the content but, I don't watch it because I don't understand the language, Non of the youtube channel have this kind of content like yours. If you know any English youtube channel like yours. Please tell me
Sir we will try to put captions in our videos as we make progress we actually started the channel for the Hindi speaking audience but we didn't know that you all are so much desired to seek knowledge . Till then please try to understand the concept as shown in the video we are starting to work on the same issue Thanks ☺️👍
=VLOOKUP($K$15,CHOOSE(VLOOKUP($K$15,$S$5:$T$9,2,0),$A$5:$E$8,$A$10:$E$13,$A$16:$E$19,$A$21:$E$24,$A$26:$E$29),COLUMN(B5),0) i have used this ist formula but it is not applying in iind row please tell the solution or mistake...
Hi Sir very good morning... Ur teaching is fantastic.. I have a doubt in excel can u pls clarify me. Can i have ur email id.. will send via email in detail pls
सर आप हमेशा MIS Excel Interview Questions बहुत ही अच्छा लेके आते हो | आप हमेशा मुस्कराते रहे |
धन्यवाद संदीप जी ,आपके शुभकामनाएं के लिए
Sir, About Q4 we can give them named range same as player name and use the cell reference from dropdown list in indirect function argument.
Your teaching tips very good and unique
Team videos r amazing since ur givinh explation in it difficult understand who doesn't know hindi
So try make two versions like one in English and other hindi so that it ll be helpful all audiences irrespective of language.
And also try post vidoes technical oral and hr questions how to answer them
Karthik from my perspective hindi audience is my first priority and as more that half of the population understand hindi it can we very helpful for them i am trying to deliver awesome content and trying to make changes in my content to make it more understandable so dont worry there is a lot to come. And you can also check out my excel live interview series there you will find your desired questions and u can practice over them
दंडवत प्रणाम गुरुजी।
Last question me Grater than D4 aayega naa sir. 0 se bada and 20 se chhota.
Weldone sir, you have a graet job, Just go head and keep it up
Thanks Rohit Ji Happy learning
and completed your two playlist..power pivot , pivot table and excel course waali chl rhi h..or sath sath ye interview waali bhi chl rhi h
Great
Sir jitni jldee aap hme videos mei bta rhe ho.... Utni hi speed mei interview mei ker dete ho kya solve.....
Sir 4th questions 😕 filter ka zariye ho sakta ha kya ... Alt+A+Q with macro_?? Jo filter macro video ha na ..us tarah
Attempt krke btaiye sbse..
Sir, Question 4 is not working even after I changed the sheet and made it in a whole new sheet. Same thing is happening, values are not changing according to the drop-down list
Sir pdf file by data mai jake query wale se nahi la sakte kya... Pls help
Selective questions are very important and intresting..and this video very helpful..
.
.
And frequency and arrey function really confused mee..
nice video #interviewcracker
Sir , in question number 3, when applying "if" with "small" than it will calculate all the smallest value even if these value are blue or not, suppose if I take red as 5, then calculation that I am getting is different,
How this formula can be improved
Please reply
Hi sir agr hum isme condition formating se small 3 blue value higlight nhi kre or value usi sheet per disply kre to kounsa formula use honga
At 6:50 the conditional formatting formula is not returning the smallest 3 values, but its showing those rows wherever blue is available. Please let me know how to resolve.
Great explanation sir,I got the solution of my query..Thank you
Thanks Tausif,Hope it helps and you got the solutions for the same.Hv a I career ahead
Really superb sir
Thanks sir so much good
Thanks for your valuable effort for us once again thanks
Thanks dear..
sir kya ye question no 4 choose se kiya jaa sakta hai. i have tried but result is not coming if possible please share the formulas. because u have already said different table me se data uthanke ke choose with vlookpup use kiya jaa sakta hai
Haan kiya ja skta haim.apne kya attempt kiya hai wo dikhao..aur kya error aa ra hai
sir,Q.no.4 ka automation nhi ho raha hai, whenever i change the player name,details arent changing automatically,i have to do the table array process every time,(edit and ctrl+shift+enter)
Sir, word count me agar 2 word ke beech me 2 ya usse jyda space hai tab wo function work ni krega
Is condition me hum text ko lene se pahle trim ka use kr sakte hai
Sir, I am using vlookup + choose for the cricketer question but only first row values are extracted, 2nd row values are same as row 1 , no error .
Pls advise, I have asked this question in comment below as one of ur user had same issue too.
Appreciate your advise
Thanks
Which question you are taking about,Kindly explain your query Kavita or you may share your query sheet @innozantofficial telegram id
Sir, question no 4 at 6:57 of this video, when player is selected all the runs should be displayed. I did try offset+ index match and it works fine but I find vlookup + choose easy so I tried that and it works only to get row 1 data but not row 2 onwards, it pulls same data as row 1.
Thanks
Kavita
Values are not changing by changing players name from dropdown list
Best questions hai
Hi sir pdf file se pivot table make kra aapne but ms word open kra phir wha se open with kaise hota h blog dekha smjh aaya sab but word open h to phir open with kese plz ek bar update kre agar aap ke pass tym ho to plz 👍🏻👍🏻👍🏻👍🏻👍🏻
Ms word open kriye aur phur filr me jaake open aur wo pdf jahan rakha hai use kar lijiye open ms word me ..then easily copy aur paste to excel
@@Innozant oh ohk sir I'll try thanku
Sir offset wale question me player change karne par value change nhi ho rahi hai
4:29
sir apne is solution me 0-20 range me 0 include and 20 include kiya h.
vhi doosri trf apne 20-40 ki range me
bhi 20 include and 40 include kiya h.
aur again apne 40-60 ki range me bhi 40 include and 60 include kiya h.
jbki 20-40 me 20 include nhi hona chhaiye kyoki vo pehle hi 0-20 ki range me aa chuka h .
isi trh 40-60 ki range me bhi 40 include nhi hona chaiye kyoki 40, 20-40 ki range me aa chuka h.
sir second wale countif me apko "
Kaunsa Ques Ishu,Ye to mil hi nhi Ra Ques Jo aap range ka puch re ho.is video me to ye Ques h hi nhi🙂❤️
@@Innozant oh,
sorry sir timing glt likh di 🙏
vo 5th question h isi video ka last wala.
10:36
pe dekho🙏
Output to same hi aayega Ishu,Haan second criteria me = bhi lagayenge jab ek taraf
@@Innozant
yes sir,but output same nhi ayega alg alg ayega dono condition me.= lgana hi pdega nhi to ek number ko do bar dono range me consider krega formula.mene check krke dekha h.🙏❤
@@ishutiwari5567 frequency formula se 5,13,6 kyo aa raha hai hai pls help.....i took range 20,40,60 as bins array
Sir plz make video on Srikange, attrition, occupancy, utilization and apr report payroll
Statistical advance function and Analysis toolpack series we will start soon .Have patience ,you mag able to see these videos in Innozant channel soon.
@@Innozant thanks sir
Sir, In question no 4 when using formula you have shown when I select a player from dropdown then values does not update on that basis.
Kindly check your formula again dear..re-watch the video..you will get the solution
previous vdo me id me se name extract kiya tha..or apne right() fun. me bhi len() fun ka use kiya or mujhe smjh hi nhi aaya right or len funtion sir kya kre
Repeat video again
@@Innozant thank you sir
for ques no 4, when we are changing the player name from data validation, the scores is not changing
Kindly check again it's working fine dear
Sir mene aapki solve worksheet description se download ki hai in Q.4 me drop down list se name change karne pe score automatic change nahi ho raha hai
Isko solution bataye
Koi issue nhi hai sheet me..check kriye ek baar dear
Very interesting questions
Thanks Bhoopendra,Hope apne khudse practice kiya hoga aur seekha hoga
@@Innozant g sir
Question no 3,4 not clear sir all Question best interview sir👌🏻👍🏻
Download it and then do practice with help of video.
M confused sir, how u opened pdf in excel.
Your Teaching is excellent. The Only thing I don't like in your video is Hindi. Please put videos in the English language, So, Everyone can understand and you will get more subscribers and Views. Because I don't know Hindi you have all the important content but, I don't understand your language. Thank you and waiting for your videos in English.
See These videos don't have that many views and I wanted the content but, I don't watch it because I don't understand the language, Non of the youtube channel have this kind of content like yours.
If you know any English youtube channel like yours. Please tell me
Sir we will try to put captions in our videos as we make progress we actually started the channel for the Hindi speaking audience but we didn't know that you all are so much desired to seek knowledge . Till then please try to understand the concept as shown in the video we are starting to work on the same issue
Thanks ☺️👍
sir..word count method does not give proper output when we give five or six words when we type words in hindi
What prob ?
Sir Q4 mein as per name table change nhi ho rahi hai..
Super Sir
Thanks Dharmendra Ji👍🙂🙏❤️ Regular Practice dear ok
I want help sir
If class 1 to 5 having total student 10 12 20 22 10=74
1) Then if class total =20 then 1 teacher extra
Excel sheet share kijiye with query explanation
@innozantofficial telegram id
My formula is not getting copied when dragging down the column in this worksheet. Please share the way to get rid of this.
Why..You may savs as this file with another name and then you may attemt the same
@@Innozant Thank you. I figured it out.
Nice video
Thanks Ram,Hope apne kuch naya seekha hoga
Sir occurence kya hota hai i mean Hindi mei
Event,incident ,Ghatna❤️
PDF format is showing in coded in word
Data Analysis Ka Ek Video Sir Banayiye Mis Ka Plz
Ok Arman..Noted..Data Analytics par ek detail video bnate hain jald hi
sir aap jha bhi len() function ka use krte h na mujhe to smjh hi nhi aate h...sch me
Why
Sir isme last ques me less than zero kyu lia..greatr thn 0 nhi lenge kya
Whuch ques?
Isi video ka last ques
Frequency wala question
Sir when I select the data to write the formula.... It is not selecting the entire data..... Only one cell it is selecting... Please help
Is your woeksheet is protected?
Great work Brother
Thanks Bhati Sahab,Hope you like the concept and learn from this🙏😊❤️
@@Innozant asi video koi nhi banata aaj kl
Thanks Amit,Apko humesha innovative aur Real Job life videos aur knowledge dene ki meri hamesha koshish rhegi dear, Thanks for watching and share.🙏😊❤️
Height agar jada kam rahega to range kaise selected karege ? Sir
kaunsw no. question me dear?
@@Innozant apko kaise send karu mere que?? Sir
@@Innozant Q.4 sir
=VLOOKUP($K$15,CHOOSE(VLOOKUP($K$15,$S$5:$T$9,2,0),$A$5:$E$8,$A$10:$E$13,$A$16:$E$19,$A$21:$E$24,$A$26:$E$29),COLUMN(B5),0)
i have used this ist formula but it is not applying in iind row
please tell the solution or mistake...
Formula seems right .wht u wng ant wht mistakes or errors are showing there
Sir, I am facing same issue using vlookup + choose. Formula works to extract values from 1st but same values are copied in 2nd row. Pls advise
In question 4 when we change player name in list but values does not change.
May be there is problem in sheet ,Aap alag sheet par data copy karke khudse formula lagao.ita working fine
Sir 3 questions is not working in my system
Qu n 4 me =indirect (player ka text) enter3
❤️❤️❤️❤️
Word count ka thoda samjha me nahi aei ,sir phihe aka bara kar na easy method me.
Ok..Tapas dubara kisi video me explain kar denge
The first ques can be done using the formula counta(split(A4," ")) in google sheets.
🙏❤️
sir qno 5 offset wale mai agar range barabar na ho ,,,,kam jyada ho to kaise hoga pls help
dynamically update krana hai..launga video
@@Innozant ok sir i will wait jaldi lana video thanxx
Sir.... Offset wala dynamic kara do plss
Open with ni hui file ms word me Excel pdf office 10 h mere pass
Hoga..office koi bhi ho not an issue
@@Innozant nhi hua other language me open hui h
Motivation Ka video banao
Thanks Ram for suggestions,Sure sochte h is baare me
Lijiye Ram ..Maine aapki baat man li ha...Must watch..Career Possibilities video.
5th q me & kyu use hua h please explain
To conatenate one text with another
Sir how connect with you
You may call/WhatsApp us , Contact details available in our website or youtube about page
Right to left vlookup lgana btao
Vlookup sereis me jaiye aur Reverse lookup using choose function la video dekhiye ...Vlookup to left and hlookup to top video Hoga
4th Q me drop down list change krne pe answer kyu change ni ho rha
Change krne pr ek he answered kyu h
Q3 very hard
koi or metthod hai pivot from pdf
get data krke table bn jati
Hi sir, Please send me excel file.
Link is already there in video description
@@Innozant thankyou so much sir,
Hi Sir very good morning... Ur teaching is fantastic.. I have a doubt in excel can u pls clarify me. Can i have ur email id.. will send via email in detail pls
Thanks Suresh Ji ..Kindly share your query on @innozantofficial telegram id
Kuch bhi samajh me nahi aaya 😢
Pehale concept seekhiye playlist se tabhi interview series aayega samjh
Ye glt hai
Kya galat batayen?
??