@@Innozant Are mai bas bolraha ho sir nazar mat hoiye aap...😊Aap ke videos dekh kar bhi bohot kuch shikhta ho sir mai. Thank you so much for your video.😊
@@razamoulvi8801 Raza Moulvi Sahab ..Mujhe to saalon me kabhi gussa aata hai,Narajgi kis baat ki wo bhi aapse,Mujhe acha lagta hai ap kai alag methid try karte hain..Checked your answer..Nice attempt with Indiex and small.Ye Question already interview cracker series me maine index se bataya hua ahi but yahan jo topic chal raha hai usko cover karna hota hai na dear..Thanks for watching and suporting.
1st Question answer without any Helper Coloum :- =INDIRECT("A"&SUM(COUNTA($A$1:$A$14),COUNTBLANK($A$1:$A$14))-ROW(A1)) or =INDIRECT("A"&SUM(COUNTA($A$1:$A$13),1)-ROW(A1))
Sir ji, I have seen your more than 100 videos, but today's video is superb, awesome and fantastic. Aaj ki video me sare function ese the jo office me maximum used hote hai 🙏❤️. Mujhe sirf nestedif ke bare me hi pata tha par aaj nested vlookup ke bare me bhi seekha😀. 🙏🙏🙏
Ist question Mai normal series 1 to 13 bana skte fir data sort kr dete z to a then may it is also a good trick but with formula ur method is osm 💯💯💯👌👌😊😊🤗🤗
Sir ji question itne interesting hote hai ki dil karta hai ki video khatam hi na ho or sir ager machine round clear ho jaye to kitne percent chance hote hai job lagne ke
Thank you sir for Example question with logical and correct solution & along with this making available Excel sheet for practice really its mean a lot in ton. Thanks Once Again for your great initive for us.
Sir sach mai aap great ho. 20min ka video pata hi nahi chala kaab khatam hua pata hi nahi chala lagra tha bus shikta jaau mai aur kya hai aagai esh video mai. Practice karkai maja aagya muje abhi. 3baar practice bhi kar li mainai. Aapkai har video muje ek nayi disha daitai hai muje. God bless u. Aapka sath hamesa uhi bana rahai.
Sir mujhe ye jan na hai ki MIS ke job ke liye mostly kya jruri hota h like formulae mai please agr possible ho to ap bata dijiye apki videos bhut helpful h mre liye thank u uske liye♥️
Another solution of first question 1. Copy entire data and paste at destination place 2. Write series no. Starting from 1 till end in helper column 3. Select pasted data with helper column and apply sorting by number largest to smallest.
sir me mis report ki interview dene gyi thi unhonhe mere se question puche ki excel ki koi limitation hai and filter or vlookup me difference h sir inka answer batadijiye mera doobara se interview h 2 tarik ho plz
Offcourse limitation hai...Excel me jab hum large amount of data.par work karte hain to issue aate hain bht isiliye ETL tool power query ki jaroroorat hoti hai. Aap btana ki sir excel me maximum rows 10 lac ke approx hai man lo mere paas 40 lac line item hai ti excel ke through process Krna possible nhi hoga na.
Rahi baat filter ki to uska kaam data extract karke lekenaana hai kisi bhi data set me se..aur vlookup ka perspective alag hai..aap google krke ek baar diffence based answer dekh lo Best of luck Asha
Thanks aapke valuable appreciation ke liye dear..ye to sahi keh rhe hain aap..Jadoo excel wale video hi audience ko jyada pasand aaye hain na ki in depth detail course..kaun itna dimag lagaye 😊😊😅
![เปิดบ้าน โคตรสวย ป๋องกพล รู้จักตั้งนาน เพิ่งรู้ว่ารวย!!! l [Nickynachat]](http://i.ytimg.com/vi/tmgCF_2HfYI/mqdefault.jpg)
you are great sir..................👈👈👈
Very very very very very very very knowledgeable video dilip jha sir thank you so much & good evening
Great Guruji..Thanks
Great sir
Thnq sir
Youre amazing sir.
Sir apka to fan ho gya mai . Bs wait hai VBA ka
❤️🙏
Amazing series sir good night
Practice jaroor karna Satish .❤️🙏👍
Needful..sir..
Thank you for intersting video
Super sir ji thank you.
I learn from this vedio vlookup limitations.
Thanks
Thanks Ghanshyam ji
@@Innozant most welcome sir. Thank for reaching us Sir
Perfect and best.
Thanks Tejpal... Practice kijiye ..ques Ka .saare 👍❤️🙏
Sir bahut kamal ke questions and series aati hai apki 👍👍
Thanks Human Sahab❤️🙏👍
Bahut hi badhiya jii... interesting question h saare..😍❤❤
Thanks Jitender ..Practice jaroor karna ..👍❤️🙏
@@Innozant jii sir.... File download kar li h....
Really knowledgeable
👍🙏❤️
🙏🙏🙏🙏...sir Aap Bhujpuri language use kiye h Output me chahathen..
🙏
Question no.3 Bina helper column ke karke batao sir😉
Puch rahe hain ya test le re hain wo bhi Mera..🙂Aayiye phir online live aur jitna query ho puchte jaiye🙏❤️
@@Innozant Are mai bas bolraha ho sir nazar mat hoiye aap...😊Aap ke videos dekh kar bhi bohot kuch shikhta ho sir mai. Thank you so much for your video.😊
@@razamoulvi8801 Raza Moulvi Sahab ..Mujhe to saalon me kabhi gussa aata hai,Narajgi kis baat ki wo bhi aapse,Mujhe acha lagta hai ap kai alag methid try karte hain..Checked your answer..Nice attempt with Indiex and small.Ye Question already interview cracker series me maine index se bataya hua ahi but yahan jo topic chal raha hai usko cover karna hota hai na dear..Thanks for watching and suporting.
1st Question answer without any Helper Coloum :-
=INDIRECT("A"&SUM(COUNTA($A$1:$A$14),COUNTBLANK($A$1:$A$14))-ROW(A1))
or
=INDIRECT("A"&SUM(COUNTA($A$1:$A$13),1)-ROW(A1))
=INDIRECT("A"&(ROW(A$14)-ROW(A1))
Try this one.
Sir ji, I have seen your more than 100 videos, but today's video is superb, awesome and fantastic.
Aaj ki video me sare function ese the jo office me maximum used hote hai 🙏❤️.
Mujhe sirf nestedif ke bare me hi pata tha par aaj nested vlookup ke bare me bhi seekha😀.
🙏🙏🙏
Thanks dear... Practice file uploaded..Kindly do the Practice for the same.Hope you enjoy the questions 🙏👍❤️
👍🏻👍🏻👍🏻
Thanks Ansh🙏❤️🙂
Ist question Mai normal series 1 to 13 bana skte fir data sort kr dete z to a then may it is also a good trick but with formula ur method is osm 💯💯💯👌👌😊😊🤗🤗
Haan mayank..bilkul kar sakte hain..But wo jugar ho gya usse better formula ydi use karen wo jyada effective
@@Innozant yes u r right and thank you
=INDIRECT("a"&ROW($A$14)-ROW(A1)) reverse order ........................
Good effort
Maja a jata hain
Thanks Dear Salil
Sir ji question itne interesting hote hai ki dil karta hai ki video khatam hi na ho or sir ager machine round clear ho jaye to kitne percent chance hote hai job lagne ke
Love you Akash...❤️🙏Machine round clear Kar Diya phir to apna kaam done .Uske baad to formality round and select sure.👍🙏
Thank you sir for Example question with logical and correct solution & along with this making available Excel sheet for practice really its mean a lot in ton.
Thanks Once Again for your great initive for us.
Thanks Shivkesh ji for wonderful and valuable feedback.❤️🙏🙂Your words really mean a lot to me.👍❤️
❤️
Sir sach mai aap great ho. 20min ka video pata hi nahi chala kaab khatam hua pata hi nahi chala lagra tha bus shikta jaau mai aur kya hai aagai esh video mai. Practice karkai maja aagya muje abhi. 3baar practice bhi kar li mainai. Aapkai har video muje ek nayi disha daitai hai muje. God bless u. Aapka sath hamesa uhi bana rahai.
Practice file uploaded.🙏❤️ Thanks Sandeep Ji
How to freeze in firt question
Kaunse query me Priyanka..Freeze using F4 krenge dear
Kaash week main 2 Saturday hote interview series ka wait nahi karna hota😁👌🏻😂😁shandar
Thanks Puran..Itna pyar dene ke liye....God bless your dear...❤️🙏👍
Sir mujhe ye jan na hai ki MIS ke job ke liye mostly kya jruri hota h like formulae mai please agr possible ho to ap bata dijiye apki videos bhut helpful h mre liye thank u uske liye♥️
Advanced Excel strong kijiye apna saath hi SQL ki knowledge bhi jaruri hai
@@Innozant ok sir thank u so much♥️
First question alag answer
=Index ($A$1:$A$13,rows(A1:$A$13)
Dont freeze rows first reference number A1
Very good attemt..Keep learning ❤️
@@Innozant Thank you so much sir.... I am learning more than my coaching centre from you ... ❤️❤️
Dear sir.....
Mujhe last wala question me thoda doubt hai, because countif to criteria according count karta hai.. to isme kaise work karta hai.....??
Dear yahan bhi to criteria hi hai ki color usi value ko Karo Jo niche diye range me mil Jaye..hai na🙂❤️❤️🙏
@@Innozant okk sir.. Thank you 😍😍😘
Sir apne btaya nai mene pocha tha k agar cell me value (2+2) kuch is trah se likhi ho to uska sum kaise kare gy ??
Cell me 2+2 likha hai matlab..phir to as a text likha hoga ye..use no. Convert kriye then apply calculation
Another solution of first question
1. Copy entire data and paste at destination place
2. Write series no. Starting from 1 till end in helper column
3. Select pasted data with helper column and apply sorting by number largest to smallest.
Good Mohit... Formula based solution kariye Kuch☺️❤️👍
Sir.. agar vlookup me value error aaye to isko solve kese krenge wo nhi btaya. please btaiye.
or MIS me job opportunity kis level tk ki h. wo b btaye.
sir me mis report ki interview dene gyi thi unhonhe mere se question puche ki excel ki koi limitation hai and filter or vlookup me difference h sir inka answer batadijiye mera doobara se interview h 2 tarik ho plz
Offcourse limitation hai...Excel me jab hum large amount of data.par work karte hain to issue aate hain bht isiliye ETL tool power query ki jaroroorat hoti hai.
Aap btana ki sir excel me maximum rows 10 lac ke approx hai man lo mere paas 40 lac line item hai ti excel ke through process Krna possible nhi hoga na.
Rahi baat filter ki to uska kaam data extract karke lekenaana hai kisi bhi data set me se..aur vlookup ka perspective alag hai..aap google krke ek baar diffence based answer dekh lo
Best of luck Asha
thankyou so much sirrr 2 june ko mere phir se interview hai once again thankyou i wish me select ho jao bas
@@AshaKumari-lt7my Interview kaisa rha?
Itne ache ache video hone ke baad bhi aapke views itne kam kaise ho skte hein jabki baaki sabhi ke views lakhs me hote hein...it's not good
Thanks aapke valuable appreciation ke liye dear..ye to sahi keh rhe hain aap..Jadoo excel wale video hi audience ko jyada pasand aaye hain na ki in depth detail course..kaun itna dimag lagaye 😊😊😅
Sir mis course krne ke bd highest kitna earn kr skte hai
It depends .. Skills and Organisation is the key factor to get highest salary
Bhai Apna Email do , I will send a data set to you.
@innozantofficial telegram id
🙏