Excellent. You are analyzing the requirement of the present day business data, and accordingly you are screening the videos. Thanks a lot on behalf of all my excel users/learners. Watching & learning the new skills everyday. Hope coming days are most challenging videos on Excel.
Thanks Gopala Sir for such a valuable & wonder inputs from you.Will always try to make real time issue our candidate facing while working on projects.Thanks sir.👍♥️🙏
बहुत ही interesting example है इसको बहुत ही ध्यान से सिखा थोडे से complex's लगा लेकिन बहुत ही मजा आया सर । सर माफ करना आपके कुछ बहुत ही बेहतरीन बातो को वैसी की वैसी ही टाइप कर देता हु लेकिन आप समझाते समय जो ऐसे sentence use करते हो तो सीखते समय tutorial मे बने रहने मे बहुत मजा आता है और concept बहुत ही मजबूती से clear हो जाते है 🙏🙏🙏🙏🙏🙏🙏
Your style of teaching is really good and give in depth knowledge on every topic. I have become a expert now by watching you videos. It helps me daily to complete my work smartly and faster. Thanks🙏
Whi Bola Sandeep ki aaj upload hote hi Dekh liye..otherwise ap late night dekhte h sayad.Thanks dear for learning and enhancing your skills in regular basis.
your way teaching and method of explanation are good enough for us. if anybody want to learn than learn the beauty of explanation than i suggest your name only.
Thanks Hemant Ji..Hooe you like the Data Pulling concept using funcation.Although it is possible through pivot easily but some how it may help you in future.
I need one help. I have one sheet in which data comes from another sheet. In this new sheet there are some data blank in 1 row (suppose row 'X"). I want only filled data from that "X" row with all other rows & column to another sheet automatically. How can it be done??
Excellent explanation of the indirect function. Sir would you like to help me to get total count of a specific text from multiple same range of multiple sheets?
Hi sir can u please explain apne alagse niche alphabets kyu likhe? Kya hum uppar wale alphabets nahi le sakte. Please sir bata denge toh confusion dur hogi.🙏
Dear Excel ke sirf main Kuch tricks video Nahi Bana Raha hu .. Complete course tutorial upload Kar ra hu.Have patience dear saare series Aayenge time ke saath.🙏♥️
Sir, Thank you so much. But maine practice kiya aur dekha ki agar main "Mainsheet" ke alawe koi dusra name deta hoon like "Source Data" and so on to ye "Ref" error show karta hai. Please suggest. 🙏
@@Innozant No sir query nhi h but I just want to learn the concept of CHAR and code function. Anyway I will figure it out sir. Thanks for Teaching us. I have been following you for last 2 months sir. Nd now innozant is my favourite TH-cam channel ❤️. Glad to talk to you Sir🙏🙏 stay safe stay happy.
{=IFERROR(INDEX(MAINSHEET!A$2:A$10,SMALL(IF(MAINSHEET!$D$2:$D$10="NOKIA",ROW($A$2:$A$10)-ROW(A2)+1,""),ROW(1:1))),"")} Ye array function use kiya hun sir, isse kisi bhi helper column ke bina ho sakta hai. Bahut try karke kiya hun ek baar dekhiyega sir please.
Hi brother 2 doubts am working with a corporate data with rows 5000 and 95 Columns and need to update Master sheet into 10 seperate sheets depends on " Line of business" using Excel 2019 Doubt 1 :- Is this the best method to keep excel in minimum size Doubt 2 :- Power query and macros..vs this method which one is most reliable to keep sheet from hanging and possible excel freeze kindly suggest me the best option as am struggling with this brother 🙏
Sir, I can understand you are teaching us another good use of indirect function but I was wondering if this would be done quickly using pivot table- filter by product-show report filter pages? Please comment Thanks in advance
@@kavita8390 The main advantage of this method is that the data Automatically gets transferred into other sheets if it's entered in Mainsheet. It's absolutely Dynamic.
Hi, I liked it, But this is a long process, if we do pivot table & take product name in a filter position then we go to " option " & click show report filter pages.
I already explain it in Pivote table Video Surojit.This is a real-time use case based on indirect formula based solution .thats why trying to share with all of you. Thanks for showing your interest and learn.
=IF(General!$B6=ABDUL!$B$1,ROW(),"") This is the formula Sir You applied to transfer the record. My question is "Is it possible to apply this same formula simultaneously on multiple ledger sheets (All Ledger Accounts at once)? Thanks Shahnawaz Pakistan
sir yadi nokia vala only nokia ki hi sheet dekh sakta hai but one should be able to see his/her own summary and should not be able to view other sheets in the file.kaise karege
Sir ye jo 10 data ek sath hai isko alag alag 10 pdf me kaise convert kare ek sath Please reply sir kal bhi pucha tha apne is topic par video nahi banaya hai
Thnq sir je indirect se socha nhi tha ese bhi ho jayega main je pivot table se karta hu je bhi try kruga abb and sir plc muje suggest kre ki power query and pivot power use kru agar karu toh kab kru aur kyu kru karna chahiye ja nhi plc bata dijiye sir thq so mush
Thanks..Gaurav bht jald Power Query aur Power Pivot Ka series start hone wala hai ..depth me padhenge use bhi.kyu nhi wo bht useful hai aur apke productivity ko aur badhayega jab large data HOTA hai to its good to work on
@@Innozant ok sir main apki je sabhi Playlist ki video ko dekhta hun muje apki video mein ex... Different lagte hai toh main keya ham log apki video dekh kar aur developed hoge sir thnq
Maine bataya aapko .Pehle Basic Excel playlist Finish kijiye almost 75 videos Hain aur wo complete basic excel hai Uske baad start kijiye sorting ,Filter add filer ,What if Analysis,Array and Sumproduct then Lookup series Uske baad chart ,pivot table and Daahboard.. Kahin se BHI video Dekh Lete Hain tabhi concept nhi hai clear .step by step seekhiye aap..
Hi sir I am your new fan, Mera ek question please usko solve kijiye , jaise ek sheet mein 20 names hain or dusri sheet mein 11 to value kaise nikalenge bina vlookup, index match ke ???
It's nice but Maine range k liye upr kuch row add kri to its not working so as per my opinion hme main sheet ka hi row mai cell value uthani chahiye condition dete time so row ka issue na aye
Dear Sir AOA i like your teaching method Sir i have a problem please make a video to solve how we can Put Up Vlook up formula on multiple Sheets as there are 10 Classes in My School i have made 10 spread sheets 1st to 10th & i have made spread results But there is problem i can't make One sheet of All the results & I can't connect Vlook to All sheet's please 😢
![เป็นไปได้ไหม - WanMai [Performance Video]](http://i.ytimg.com/vi/Eh5hItD4Mr0/mqdefault.jpg)
A good teacher knows the subject and knows how to explain it effectively to others. You are a good teacher. Big salute to you dear.
Thanks Haridas ..God bless You
VERY WELL EXPLAINED. CREATED SAME SHEETS SUCCESSFULLY. AMAZING. REALLY A GURU.
Thanks
Excellent. You are analyzing the requirement of the present day business data, and accordingly you are screening the videos. Thanks a lot on behalf of all my excel users/learners. Watching & learning the new skills everyday. Hope coming days are most challenging videos on Excel.
Thanks Gopala Sir for such a valuable & wonder inputs from you.Will always try to make real time issue our candidate facing while working on projects.Thanks sir.👍♥️🙏
बहुत ही interesting example है इसको बहुत ही ध्यान से सिखा थोडे से complex's लगा लेकिन बहुत ही मजा आया सर ।
सर माफ करना आपके कुछ बहुत ही बेहतरीन बातो को वैसी की वैसी ही टाइप कर देता हु लेकिन आप समझाते समय जो ऐसे sentence use करते हो तो सीखते समय tutorial मे बने रहने मे बहुत मजा आता है और concept बहुत ही मजबूती से clear हो जाते है 🙏🙏🙏🙏🙏🙏🙏
Thanks Manish ji.acha laga aapse sunke ki aap apke lofe me ye tutoriap value add kar pa rahe hain aur aap isse seekh rahe hain ..God bless you dear❤️
Great sir,
I am a big fan of your technique of teaching....
Very much different and honest .
Thanks Sanjeet Ji ..Really means a lot to me.Happy learning dear ..Have a great day..🙏❤
Such a helpfull content by Innozant channell sir !
Badhiya nahi super duper badhiya hai sir ..dilip sir ur magician❤️
Thanks Abhishek Ji🙂🙏♥️ Omg itna pyar aur respect.. m glad ..
Wow! You are excellent. Your style of explaining is excellent. Thank you very much.
Thanks Sudhir Ji..God bless you .. Happy Learning ❤️🙏
Your style of teaching is really good and give in depth knowledge on every topic. I have become a expert now by watching you videos. It helps me daily to complete my work smartly and faster. Thanks🙏
Thanks for your valuable feedback dear..Really means a lot to me♥️
Hi brother you are my life saver..💯❤️
Glad to hear that
Sir Great Teaching ! Thank you wonderful lessons. Your teaching method is so simple and your expressions while teaching is excellent.
Thanks Sandeep..aaj bade jaldi Dekh liye video.umeed hai ye concept pasand aaya hoga data pulling Ka to multiple sheet.
@@Innozant Sir jaldi nahi pura 13min ka dekha. Sir aapki video sai muje inspiration milti hai bahut. You are my mentor.
Whi Bola Sandeep ki aaj upload hote hi Dekh liye..otherwise ap late night dekhte h sayad.Thanks dear for learning and enhancing your skills in regular basis.
Always with you sir Ji. You are great human being.
Great case study of Indirect function...
Thanks dear 🙏♥️
your way teaching and method of explanation are good enough for us. if anybody want to learn than learn the beauty of explanation than i suggest your name only.
Really means a lot to me Prem..❤🙏Thanks for your love and support
I am a senior citizen of age 66 yr, but I read & see your all vedios for excel, Kindly provide Vedios vba excel
Thanks Sir. Keep exploring
Sir It's Amazing Sir
Awesome video all new concept seekh raha hu excel mai thanku sir and good night. 👌 👌 👌
Thanks Satish Ji..Hope aaj Kuch naya seekha aapne..Good Night 🙏♥️
Excellent Honorable
We can also extract using Advance filter and assigning a macros..This becomes a little tidous but it's a good eg of different variation .
Wow, very Nice explained, you are truly blessed with excellent knowledge sir, U think out of Box 🙏
Thanks Prakash Ji..Really means a lot to me dear..Happy learning
Well explained.
Great explanation with great example, thanks you sir giving us such important knowledge of indirect.
Thanks Hemant Ji..Hooe you like the Data Pulling concept using funcation.Although it is possible through pivot easily but some how it may help you in future.
@@Innozant yes sir
Wonderful vedeo sir...
Thanks dear❤️❤️
Nice sirji
Nothing can be say, only "excellent"
Excellent 👌 Sir...
Thanks Dear
Very nice sir
I need one help. I have one sheet in which data comes from another sheet. In this new sheet there are some data blank in 1 row (suppose row 'X"). I want only filled data from that "X" row with all other rows & column to another sheet automatically. How can it be done??
You are just awesome,........
Thanks Moidul sahab..
Sir you are ginius 🙏 for this wonderful topic it's really helpful to me for advanced level ❤️🙏👍
Thanks Saini sahab
@@Innozant hi Dilip sir kya aap next few months mein tally Ka course start Kar sakte ho please reply asap 🙏 sir
Fantastic
excellent
Indirect tarike se jo aapne indirect samjhaya hai kaamal hai 😊😂👌🏻
Thanks Puran...🙏♥️itne pyar dene ke liye .God bless u..Good Night
Excellent and thanks a lot.
Thanks Sohrab❤️❤️
very excellent sir
Very interesting
👍❤️🙏
Nice video sir, sir yeh question toh advance filter+macro se bhi ho jata
👍😊
very Good
Thanks Danish Sahab.🙏🙂♥️
Aap purush ho hi nhi
Mahapurush ho
Microsoft walo ko bhi aapse unka hi ye tool sikhna chahiye😛
Sir you r great :)
Mahesh ji..OMG..😜ab Rulaoge kya aap...Thankw for such a amazing comment dear...Happy learning..Seekhiye aur life me aage but jayen mera yah wish
Excellent explanation of the indirect function. Sir would you like to help me to get total count of a specific text from multiple same range of multiple sheets?
Salam Sir.
👌👌👌
Sir indirect ke liye aur videos bana do new course basic to advanced indirect
if record more then 50 or 30 then what we will do ? will we change the name one by one in formula?
how to absent employees name highlight according to date in attendance sheet
Sir direct hi filter formula or old version he ro lookup formula se easily work kr sakte the😅khamo kham hard pad jayega ye
On a daily basis I see your video but have some questions can you pls connect with me sir
Hi sir can u please explain apne alagse niche alphabets kyu likhe? Kya hum uppar wale alphabets nahi le sakte. Please sir bata denge toh confusion dur hogi.🙏
👍👍👍
Hello sr advance hyperlink ka use kese kre
Video bna dete hain adv hyperlink uses ka
Sir sirf excel sikhte ho power query ya powerpivot bhi sikha do uski demand kafi hai
Dear Excel ke sirf main Kuch tricks video Nahi Bana Raha hu .. Complete course tutorial upload Kar ra hu.Have patience dear saare series Aayenge time ke saath.🙏♥️
@@Innozant sir chhoti si zindagi hai usme time hi kha hai 😜
Sir aapki video par kafi like Dene kaa dil karta hai but ye option available nhi hota , your teaching style is very assom
Thanks dear
I observe u can also connect cell name to sheet name such as nokia
Where?
Sir ji pata karna hai date wise number pattern
Sir,
Thank you so much.
But maine practice kiya aur dekha ki agar main "Mainsheet" ke alawe koi dusra name deta hoon like "Source Data" and so on to ye "Ref" error show karta hai.
Please suggest. 🙏
Error to nhi aana chaiye
Sr overtime sheet ki bhi video bna do
Ok..Pawan Ji..yaad dilna kuch din baad bana denge
Good
Thanks Aqeel 🙏♥️
Is there any separate video of CHAR.???
Yes..pleaee find it in basic Excel playlist
Thanks for replying sir but there is not any video of CHAR function. I have already watched your basic Excel playlist.🙏❤️
Dear alagse video nhi but majne char code ke kai example kraye hain..char code me koi query hai to ask
@@Innozant No sir query nhi h but I just want to learn the concept of CHAR and code function. Anyway I will figure it out sir. Thanks for Teaching us. I have been following you for last 2 months sir. Nd now innozant is my favourite TH-cam channel ❤️. Glad to talk to you Sir🙏🙏 stay safe stay happy.
Thanks Saurabh Ji..Happy learning 🙏❤️
Sir by using advanced filter with macro it's more easier
Yes dear..true
@@Innozant sir can i use indirect when we chose list range during macro recording with advance filter?
Plz let me know
Sir mere paas 5000 rows ka data hai toh drag karne ka short cut with this function kaise hoga jabki products sheets v 50 k above hai
Utne rata kenloye ye method kyu applya kar re hain.?
To change multiple data table from drop down in excel
{=IFERROR(INDEX(MAINSHEET!A$2:A$10,SMALL(IF(MAINSHEET!$D$2:$D$10="NOKIA",ROW($A$2:$A$10)-ROW(A2)+1,""),ROW(1:1))),"")}
Ye array function use kiya hun sir, isse kisi bhi helper column ke bina ho sakta hai. Bahut try karke kiya hun ek baar dekhiyega sir please.
Hi brother 2 doubts
am working with a corporate data with rows 5000 and 95 Columns and need to update Master sheet into 10 seperate sheets depends on " Line of business" using Excel 2019
Doubt 1 :- Is this the best method to keep excel in minimum size
Doubt 2 :- Power query and macros..vs this method which one is most reliable to keep sheet from hanging and possible excel freeze
kindly suggest me the best option as am struggling with this brother 🙏
I LEAN VLOOKUP BY YOUR VIDEO .. BUT I HV TEXT IN TWO COLUMAN N LOOKUP FOR 4 THE COLUM MESN I LOOKUP FOR EITH TEXT FILD.. IS IT POSSIBLE
Sir, I can understand you are teaching us another good use of indirect function but I was wondering if this would be done quickly using pivot table- filter by product-show report filter pages? Please comment
Thanks in advance
Yes Kavita we can do with pivot ,But show report filter pages may show no. Of pages based on filter criteria..kindly share your exact requirement
Yes, you are right but I do require that. It works perfectly fine using pivot- show filter option the way you taught in pivot video. Thanks
@@kavita8390 The main advantage of this method is that the data Automatically gets transferred into other sheets if it's entered in Mainsheet. It's absolutely Dynamic.
Hi,
I liked it,
But this is a long process, if we do pivot table & take product name in a filter position then we go to " option " & click show report filter pages.
I already explain it in Pivote table Video Surojit.This is a real-time use case based on indirect formula based solution .thats why trying to share with all of you. Thanks for showing your interest and learn.
=IF(General!$B6=ABDUL!$B$1,ROW(),"")
This is the formula Sir You applied to transfer the record.
My question is "Is it possible to apply this same formula simultaneously on multiple ledger sheets (All Ledger Accounts at once)?
Thanks
Shahnawaz
Pakistan
Eg . Sir agar main Nokia cell main likhata hoon to muje nokia ka sara data aana chahiye kya ho sakta hai
Kya pass kar re hain formula aap..kai method se ho sakte hmmindex match use kr lijiye.
sir yadi nokia vala only nokia ki hi sheet dekh sakta hai but one should be able to see his/her own summary and should not be able to view other sheets in the file.kaise karege
Sir ye jo 10 data ek sath hai isko alag alag 10 pdf me kaise convert kare ek sath
Please reply sir kal bhi pucha tha apne is topic par video nahi banaya hai
Thnq sir je indirect se socha nhi tha ese bhi ho jayega main je pivot table se karta hu je bhi try kruga abb and sir plc muje suggest kre ki power query and pivot power use kru agar karu toh kab kru aur kyu kru karna chahiye ja nhi plc bata dijiye sir thq so mush
Thanks..Gaurav bht jald Power Query aur Power Pivot Ka series start hone wala hai ..depth me padhenge use bhi.kyu nhi wo bht useful hai aur apke productivity ko aur badhayega jab large data HOTA hai to its good to work on
@@Innozant ok sir main apki je sabhi Playlist ki video ko dekhta hun muje apki video mein ex... Different lagte hai toh main keya ham log apki video dekh kar aur developed hoge sir thnq
M happy dear . Thanks
Sir me advance excel kaise sikhu please help me
Maine bataya aapko .Pehle Basic Excel playlist Finish kijiye almost 75 videos Hain aur wo complete basic excel hai Uske baad start kijiye sorting ,Filter add filer ,What if Analysis,Array and Sumproduct then Lookup series Uske baad chart ,pivot table and Daahboard..
Kahin se BHI video Dekh Lete Hain tabhi concept nhi hai clear .step by step seekhiye aap..
Hi sir I am your new fan,
Mera ek question please usko solve kijiye , jaise ek sheet mein 20 names hain or dusri sheet mein 11 to value kaise nikalenge bina vlookup, index match ke ???
Data. Sheet share kijiye ..kya chahte Hain wo btaiye usme se kis value ke base par nikalna chahte Hain.🙏Thanks for being part of Innozant Family.♥️
@@Innozant sir. Mujhse interview ke time pucha gya thaa, to apan koi bhi data le sakte but , vlookup, or index match ki bina value nikalna hai.
It's nice but Maine range k liye upr kuch row add kri to its not working so as per my opinion hme main sheet ka hi row mai cell value uthani chahiye condition dete time so row ka issue na aye
👍❤️
Jab Name change kr rha hu formula mein Nokia ki jagah Sony to formula work nahi ho raha hai ?
aisa kyu ?
Dear Sir AOA i like your teaching method Sir i have a problem please make a video to solve how we can Put Up Vlook up formula on multiple Sheets as there are 10 Classes in My School i have made 10 spread sheets 1st to 10th & i have made spread results But there is problem i can't make One sheet of All the results & I can't connect Vlook to All sheet's please 😢
Please upload new video in excel
🌟🌟🌟🌟🌟
❤️
What if nokia is in 2011 4 entry
Very nice sir