you are God Sir .you are totally different from others .Free Classes koi itna badiya se nhi batate .Bhagwan apko khush rakhe hum jaiso pr apka bahut upkar h sir.
Thanks Sunil..Really means a lot..Main kosish kar raha hu Premier course Free me provide karne ki...Umeed hai in course se aapke life me value add ho rahe honge
Step by Step saare concept seekhenge aarto aur phir dashboard bnane ki koshish krenge to its reallys simple and interesting...Aayega samjha aur mujhse jyada acha design kr skate hain ap..Ye yakeen ap khud par aur thora sa mujh par 😄bhi kar sakte h
सर आपसे Dashboard सीखने मै मुझे बहुत ही अच्छा लगरा है | मै daily आपके सारे विडोज़ revise करता रहता हूँ | मेरा डेली का रूटीन बन गया है जबतक आपके विडोज़ revise नहीं करता मै तब तक मैं प्रैक्टिस करता ही रहता हूँ | आप बहुत ही अच्छे शिक्षक हो आपको कोटि कोटि प्रणाम | सर मैने August To November हल्का फुल्का solve कर दिया है | but पूरा नहीं हो पारा है | सर और आप OFFSET function पर भी tutorial बनाये |
धन्यवाद संदीप जी ,मेरे वीडियो को इतना ज्यादा पसंद करने के लिए,और आप बहुत अच्छा सीख रहे है ये आनंदित करता है मुझे ,जरूरा आप चैनल पर बने रहिये आपको हमेशा वीडियो मिलते रहेंगे
Thanks Faiza for lovely comment,Hope you like the videos and have started learning step by step from there. It seems you are a new member of Innozant-Seed of Success Family.We welcome you dear to experience the taste of success. If you are a beginner learner then we recommend you to start with Basic playlist 1st video onwards step by step videos are uploaded there and practice file are there in Description common link provided. For issue /query during your practice feel free to connect us via Telegram - @innozantofficial Thanks & Regards Team Innozant
Hi Team Innozant ur videos r too good and informative But It Difficult to understand Hindi lot of Southies also watching ur videos try to make a videos in English as well .Hope you get it
Hi, I am stuck with the Offset formula. I have done it step by step as shown by you but the Month is changing only until Feb and the Productivity and Target details are not even coming up. Please assist. Loving your videos. They are very very helpful.
You are doing minor mistake Archana..Recap video and apply step by step as I explained in video..Still you are facing issue..kindly share your sheet @innozantofficial telegram id ..Will guide you for the same.
@@Innozant Thanks for your response! I followed all the steps and was able to get the chart correctly. Everything is changing according to the Month selected. My only confusion is that the Month Productivity and Target Values are not changing properly where the Offset formula is. But the information is changing correctly on the chart. I was wondering why it was like that..
Namaste sir, app ka video hamare liye bahut helpful hai.. Sir app jese bataye hum bilkul wayse custom mein jake Mmm likha lekin drop down me jo hai, formulla bar me v ohi dekh ta hai... Please help me sir
Very informative video sir but i want to ask that if months are horizontal in data sheet and productivity and targets are vertical how can we use this formula
@@Innozant sir Mera Ek problem hai ye sb karne ke bad mai jaise hi Chart Title ko slect karta hu to mera Formula Bar Hide ho jata hai aur Mai Ume koi formula enter nahi kar pata Bta skte hai aisa kyo horaha hai
Ye video me bahut problem arha...1)Offset lagane ke baad jaise month change krrha 'spill' arha 2)chart me edit me jakr name daal raha to waha b error..kaise theek hoga sir ?
HI SIR, I HAVE ONE DOUBT. I AM STUCKED HERE IN THIS VIDEO WHILE LEARNING FROM UR DASHBOARDS PLAYLIST. I AM APPLYING SAME FORMULA AS IN YOURS. BUT I AM GETTING SPILL IN CELLS. MEANS... jaha formula lagaya hai OFFSET ka ,formula lgane ke baad niche numbers likhe aa rahe hai. i.e. SPILL . KINDLY ASSIST WHAT TO DO . THANKS FOR UPLOADING CLASSES IN A VERY EASY WAY.
@@Innozant play list for data cleaning.. I mean the procedure,I had seen sir,text to columns I'm asking to keep them as a play list if possible..only for (data cleaning)
Hi bro, I have create 1 dashboard where i created 12 multiple graphs in it along with the slicers and Multiple pivot tables (earlier it's was Static but now it's a Dynamic), when I am going to connect the slicers via right click i.e. Report connection, it shows only 3 graphs, however it should shows us to 12 multiple graphs so that I can connect to each other. Please note, earlier when pivot table was static then easily it shows 12 graphs and I connected to each other but when i used dynamic pivot table with the help of offset formula and then this issue is creating....I hope u understood and Please help me if you can ? Please Note, I refreshed data many times , but still it shows 3 graphs only.
Apply dynamic Line chart if you want to compare sales or revenue amount between these years.The process is same as i already upload dynamic chart videos.
Sir, BPO center me use hone wala dashboard evam sabhi prakar ki reports ka ek complete session bnaiye. Kyonki hm Jha Kahi bhi jate hai to we experience puchte hai. So we unable to tell them anything.
Yes right,that means when we convert a single range into table there is no need to update source data as it's dynamically updated even if we freeze the data range on our formula
Hi good evening sir, Sir is dashboard me jab month wale column me offset ka formula laga rha hu to jan tk sahi jab month change kar rha hu to spill error aa rha hai kyoki height month ke according bash ja rhi hai =Offset(jan address,0,0,match(month ki drop down list address, month ki puri list,0),0) Please check sir.
When you use offset function in M2 cell and press enter key, it is displaying number, why? And when i tried this function as u explain in this video,it gives #value error. Plz explain
Dear Adnan #NA Ka matlab hi yahi hota hai ki , incorrect argument used on formula.. Check kijiye ya to jise refer kar rahe hain wo dataset me nahi hai ya jo naming range me value hai use aap refer hi nahi kar re h
I am Writing mmm in custom format but in my formula bar not showing date when selecting month from dropdown. As a result I Couldn't use offset. Please tell me how do this.
When I try to use Month Formula as a reference in productivity it is showing NA. I have watched the video many times but it still can't help me. please tell me what should I do.
Dear sir, i could not get answer while showin an error # N/A in dash board productvity vs target error raised in productvity = offset( month 0,1) answer i could nt found please give me solution for that complication.
Very nice videos on dashboard, much appreciated. I have a query , I am using A1 as my reference in offset and 1- row , 0- column but it does not work, why?
Suppose, I have Jan month and using same offset+ match, output I am getting is Jan, Feb Not sure why? I don’t get any no as output but Jan, feb . Pls advise
Sir, pls advise as I think the problem is not with the offset formula but Month format which I am not able to change to mmm as you advised earlier in this video. Even after selecting mmm , it is not showing in that format. Appreciate your advice here
at 08:03 in your video there is no (SPILL FORMULA), my months are showing till the month of drop-down list month using offset formula. It shows (SPILL FORMULA). what to do??
My OFFSET function is showing only Jan Value nothing else. ......allready Watched Many Times. set custom format to mmm but My offset is showing only Jan in Month. and Productivity and Target shows #N/A error
Time stamp 10:53 mein aapne month Jul select kiya h, but productivity 91 aur target 96 aa raha h....so iss chiz ne confuse kar diya mujhe. Pls thoda samjhaye.
Hello sir I'm getting stuck when I try to make a chart dynamic when I click on target line and edit the target error is coming that excel found a problem with one or more formula references in this workbook tried so many time and when I edit the productivity no error is coming only happen at the time of target editing.kindly give me solution
Resp sir Namastey!!!! Mai video Ko dekha ur custom Wali jagah par utak Raha Hu mujse nhi Ho Raha Please meri madat kijiye pls help by me mai is screen shot ki picture b bhej Raha hu jaha atak Raha hu Data validation Mai months dikha Raha h apki video mai Ur upper status bar mai date Mere se ye nhi Ho Raha please madat kare meri Namastey ke sath apka student
I have done the same thing the way you have show in the above description however i am getting #value error. I have tried with the number format as well however result remain the same in first offset (month)formula.
Sir i have one confusions, when I try to links months list in this vedio my list not working properly, and could not find this file link , i am your new visitor, kindly help me and send me link of this file personally on my email 🙏
Which file Aarti..?Kindly send your query on mail id-innozantcampus@gmail.com You are Not Visotor Aarti..You are now a Member of Innozant Family..Happy Learning Dear..Have a wonderful career ahead.
@@Innozant Jha Ji hum Excel 365 use kar rahe hai aur is version me Jaise hi dropdown change karte hai Month ka, offset wale section me month me Month Jan se lekar dropdown k month tak aa jata hai, jo ki Productivity and Target waale offset pe overlap kar jata hai, aur spilling error deta hai, aap email id bhej dejiye, hum aapko apni excel sheet bhej denge
While Practicing this Dash board im getting error Productivity and Target Getting error #NA I have declarer name range and did as process same as videos still getting error can you please help me to sort the issue
Sir ji aap video industrial excel aur VBA ke liye bhi banao VBA ke liye kam se kam 6 part banao sir mujhe VBA sheekna hai sir please please please please please please please please please please please please 🙏🙏🙏🙏🙏🙏
Sir i have one confusions, when I try to links months list in this vedio my list not working properly, and could not find this file link , i am your new visitor, kindly help me and send me link of this file personally on my email 🙏
@@Innozant Hello Sir, (1): When I put Offset function front of Month Column… End Enter. Its showing VALUE. Also, when I click on Formula Function in Define Name (MONTH) is not Showing on Top Column. (2): I Didn’t understand why we Copy and Paste Formula in Define Name. And sir on which link need to click for obtain RAW DATA for practice for Current video. When i click its open your all classes. Sir, I really want to say the way you Explain or Present concepts in your videos is very helpful and easy to understand.
sir....... i tried 5-6 time offset formula for productivity where we copy month (offset) formula and paste it as a refference in productivity(offset) but everytime it shows #N\A and literally i am tired by trying many times @innozant pls reply
please sir just give a hint that how can i show only that month chart which one I select. suppose i will select march month the charts will show only march month
sir I getting trouble when I apply offset formula on month then it automiacally applied on other down cells productivity and target why? a big problem for me rite now ...
Resp sir Namastey!!!! Mai video Ko dekha ur custom Wali jagah par utak Raha Hu mujse nhi Ho Raha Please meri madat kijiye pls help by me mai is screen shot ki picture b bhej Raha hu jaha atak Raha hu Data validation Mai months dikha Raha h apki video mai Ur upper status bar mai date Mere se ye nhi Ho Raha please madat kare meri Namastey ke sath apka student
you are God Sir .you are totally different from others .Free Classes koi itna badiya se nhi batate .Bhagwan apko khush rakhe hum jaiso pr apka bahut upkar h sir.
Thanks Sunil..Really means a lot..Main kosish kar raha hu Premier course Free me provide karne ki...Umeed hai in course se aapke life me value add ho rahe honge
You are really too intelligent sir, muje b ye sb aa jaye to apki mhaan kripya hogi
Step by Step saare concept seekhenge aarto aur phir dashboard bnane ki koshish krenge to its reallys simple and interesting...Aayega samjha aur mujhse jyada acha design kr skate hain ap..Ye yakeen ap khud par aur thora sa mujh par 😄bhi kar sakte h
सर आपसे Dashboard सीखने मै मुझे बहुत ही अच्छा लगरा है | मै daily आपके सारे विडोज़ revise करता रहता हूँ | मेरा डेली का रूटीन बन गया है जबतक आपके विडोज़ revise नहीं करता मै तब तक मैं प्रैक्टिस करता ही रहता हूँ | आप बहुत ही अच्छे शिक्षक हो आपको कोटि कोटि प्रणाम |
सर मैने August To November हल्का फुल्का solve कर दिया है | but पूरा नहीं हो पारा है | सर और आप OFFSET function पर भी tutorial बनाये |
धन्यवाद संदीप जी ,मेरे वीडियो को इतना ज्यादा पसंद करने के लिए,और आप बहुत अच्छा सीख रहे है ये आनंदित करता है मुझे ,जरूरा आप चैनल पर बने रहिये आपको हमेशा वीडियो मिलते रहेंगे
Sir, your teaching technic is awesome
Hello sir app ki video me bahutkuch sikh ne ko mil raha he. Yes video me aap ne bar chat par productivity ko dikhaya , target ka bar chat kese banaya
Already explain Kiya hai dear video me❤️
Sir....You are explaining each topic so understandable and patiently....Thanks for your effort and educating Excel skills.....
Zabardast Sir..thanks
Thank you Sir, I learn a lot from your videos.. I will try to give your answer..
That's good,Keep learning
Very nice sir.. i got job bcoz of u
God bless You.Happy learning
your all video something new, i have learned more day by day
i have one data, have some queries. can you suggest
@innozantofficial telegram id par send kren
Sir..i saw video mind blowing..your teaching style so so amz.👌👌👌👌👌👌👌👌. Sir i trying to require data....
Thanks dear
Very nice class
Very sweet & stylist ,thank
Thanks Salil ji
very informative
Happy mahashivratri sir
Happy Shivratri dear
Sir, SQL ke tutorilas kab se start honge ?
Thank you very much sir for free education
Thanks Shubham..God Bless You
Dear Sir, thank very useful class.
Thanks dear ..GM❤️
Explained Super star🙏
Amazing Explaination Sir..
Thank you sir
Real teacher
Thanks Faiza for lovely comment,Hope you like the videos and have started learning step by step from there.
It seems you are a new member of Innozant-Seed of Success Family.We welcome you dear to experience the taste of success.
If you are a beginner learner then we recommend you to start with Basic playlist 1st video onwards step by step videos are uploaded there and practice file are there in Description common link provided.
For issue /query during your practice feel free to connect us via Telegram - @innozantofficial
Thanks & Regards
Team Innozant
great desh board sir
Thank you so much sir
Very useful video..thnks sir
Dashboard is really interesting 😍
Hi Team Innozant ur videos r too good and informative But It Difficult to understand Hindi lot of Southies also watching ur videos try to make a videos in English as well .Hope you get it
Yes the team is working on the subtitles we will definitely try to implement your ideas thanks a lot Karthik 🙂
Hi, I am stuck with the Offset formula. I have done it step by step as shown by you but the Month is changing only until Feb and the Productivity and Target details are not even coming up. Please assist. Loving your videos. They are very very helpful.
You are doing minor mistake Archana..Recap video and apply step by step as I explained in video..Still you are facing issue..kindly share your sheet @innozantofficial telegram id ..Will guide you for the same.
@@Innozant Thanks for your response! I followed all the steps and was able to get the chart correctly. Everything is changing according to the Month selected. My only confusion is that the Month Productivity and Target Values are not changing properly where the Offset formula is. But the information is changing correctly on the chart. I was wondering why it was like that..
Same problem
Awesome👏
Very good
Sir your video is vary vary nice super
Thanks dear
Thank you so much for amazing teaching for interactive excel.
sir it is possible by pivot table as well
Namaste sir, app ka video hamare liye bahut helpful hai.. Sir app jese bataye hum bilkul wayse custom mein jake Mmm likha lekin drop down me jo hai, formulla bar me v ohi dekh ta hai... Please help me sir
Naming range me jaise likhe hai waise hi lijiye .
Case sensitive h
Very informative video sir but i want to ask that if months are horizontal in data sheet and productivity and targets are vertical how can we use this formula
You are the best, Always! Thank you for uploading great video ❤️
Thanks Vishal Ji,Hope you learn fr this video
@@Innozant sir Mera Ek problem hai ye sb karne ke bad mai jaise hi Chart Title ko slect karta hu to mera Formula Bar Hide ho jata hai aur Mai Ume koi formula enter nahi kar pata Bta skte hai aisa kyo horaha hai
Superb sir 👍🙏
Thanks Ashish ji..gn
Great sir , I like your video. Pls share excel dashboard learning playlist.
Thanks Amit ..excel dashboard playlist is there please find it in channel
Sir, offset run karne ke baad month serially show hone lagta hai, kya kiya jaye?
Ye video me bahut problem arha...1)Offset lagane ke baad jaise month change krrha 'spill' arha 2)chart me edit me jakr name daal raha to waha b error..kaise theek hoga sir ?
HI SIR, I HAVE ONE DOUBT. I AM STUCKED HERE IN THIS VIDEO WHILE LEARNING FROM UR DASHBOARDS PLAYLIST.
I AM APPLYING SAME FORMULA AS IN YOURS. BUT I AM GETTING SPILL IN CELLS. MEANS... jaha formula lagaya hai OFFSET ka ,formula lgane ke baad niche numbers likhe aa rahe hai. i.e. SPILL . KINDLY ASSIST WHAT TO DO . THANKS FOR UPLOADING CLASSES IN A VERY EASY WAY.
sir, if possible create one play list for data cleaning..like using text to columns, find replace, substitue and all
text to column videos are already there in data validation playlist.
@@Innozant play list for data cleaning.. I mean the procedure,I had seen sir,text to columns I'm asking to keep them as a play list if possible..only for (data cleaning)
oh..thats good suggestion..You want a seprate playlist for data cleaning technique.Ok..dear
@@Innozant thank you sir💐
Nice
very nice sir
Sir can we make the same for weekly basis
♥️👍
Sir vo month ke right side drop down option kaise aarha tha that arrow 🔽 plz know us
sir if you have any Q&A Whattsapp group where we can ask question and quries ...
@innozantofficial telegram id
Hi bro, I have create 1 dashboard where i created 12 multiple graphs in it along with the slicers and Multiple pivot tables (earlier it's was Static but now it's a Dynamic), when I am going to connect the slicers via right click i.e. Report connection, it shows only 3 graphs, however it should shows us to 12 multiple graphs so that I can connect to each other.
Please note, earlier when pivot table was static then easily it shows 12 graphs and I connected to each other but when i used dynamic pivot table with the help of offset formula and then this issue is creating....I hope u understood and Please help me if you can ?
Please Note, I refreshed data many times , but still it shows 3 graphs only.
Kindly share your detailed query on @innozantofficial telegram id
Good ☺
❤️🙏
i want to make a dynamic pivote and chart report for Sales and KPI dashborad. Please help me.
Sir I have more than 10 years data and how can apply dynamic graph for such type of data.
Apply dynamic Line chart if you want to compare sales or revenue amount between these years.The process is same as i already upload dynamic chart videos.
Sir, BPO center me use hone wala dashboard evam sabhi prakar ki reports ka ek complete session bnaiye. Kyonki hm Jha Kahi bhi jate hai to we experience puchte hai. So we unable to tell them anything.
Sir in mis interview they asked my why you convert range to table I said table provide dynamic range is this correct sir
Yes right,that means when we convert a single range into table there is no need to update source data as it's dynamically updated even if we freeze the data range on our formula
Innozant sir I feel your videos are great please do videos on vba
Innozant and please provide online course detail I want to join weather you are going to provide certificate
For More details on Live Classroom training session you may Whatspp us on 7065069985.Will send you all details.
Hi good evening sir,
Sir is dashboard me jab month wale column me offset ka formula laga rha hu to jan tk sahi jab month change kar rha hu to spill error aa rha hai kyoki height month ke according bash ja rhi hai
=Offset(jan address,0,0,match(month ki drop down list address, month ki puri list,0),0)
Please check sir.
Kuch Galati Kar rahe Hain Santosh Ji..phirse video dekhiye aur samjhke Jaise maine apply Kiya hai krke dekhiye dubara same data par pehle
@@Innozant ok sir.
How did u fix this. I am having the same error, tried multiple times. Appreciate if you can advise how u fixed it pls
Thanks in advance
When you use offset function in M2 cell and press enter key, it is displaying number, why? And when i tried this function as u explain in this video,it gives #value error. Plz explain
Dear Mahima,It may shows value error but it works.
sir...offset formula jb productvity mn name range dy kr apply krty hn to N/A ka error aa jata hai. plz guide me
Dear Adnan #NA Ka matlab hi yahi hota hai ki , incorrect argument used on formula..
Check kijiye ya to jise refer kar rahe hain wo dataset me nahi hai ya jo naming range me value hai use aap refer hi nahi kar re h
thank you sir. assignment is sovled
I am Writing mmm in custom format but in my formula bar not showing date when selecting month from dropdown. As a result I Couldn't use offset. Please tell me how do this.
sir when I give height 1 then offset is work but when I give height other than 1 then the offset is not work.kindly suggest.
When I try to use Month Formula as a reference in productivity it is showing NA. I have watched the video many times but it still can't help me. please tell me what should I do.
index-match function se bhi ho sakta hai kya
Haan ..krke dekhiye attempt dear
@@Innozant Dear Sir, I visited your website , nice information, but not indicated how I can join your online class. Please guide
You may whatsapp us (Contact details provided in website) for complete course details
Dear sir, i could not get answer while showin an error # N/A in dash board productvity vs target error raised in productvity = offset( month 0,1) answer i could nt found please give me solution for that complication.
Very nice videos on dashboard, much appreciated. I have a query , I am using A1 as my reference in offset and 1- row , 0- column but it does not work, why?
Sorry, one more question sir, we can use count A for height and width but in that case how do we link it with drop down month?
You are doing right Kavita..What output shows
Suppose, I have Jan month and using same offset+ match, output I am getting is Jan, Feb
Not sure why? I don’t get any no as output but Jan, feb . Pls advise
Sir, pls advise as I think the problem is not with the offset formula but Month format which I am not able to change to mmm as you advised earlier in this video. Even after selecting mmm , it is not showing in that format. Appreciate your advice here
@@kavita8390 Yes! I have faced the same issue. getting output as Jan. it's not changing. Please Advise...
either I Squencelly follwing your dasbord series plz answer me about my query which i have mentioned in bellow
Kindly follow the course in sequence
After coping offset function define name is disabled. How to enable it
at 08:03 in your video there is no (SPILL FORMULA), my months are showing till the month of drop-down list month using offset formula. It shows (SPILL FORMULA). what to do??
Check your formula again ..it's working fine
Dear Sir, I have data need to required customized your valuable support is required to resolve the same. How can I contract you.
@innozantofficial telegram id
@@Innozant thank Sir, pl can you share your contact number, so I can explain to you.
Sir Maine offset function ko copy Kiya but name manager disable aa raha hai why please 🙏
When i edit the chart "excel found a problem with one or more formula references in this worksheet error. shown
My OFFSET function is showing only Jan Value nothing else. ......allready Watched Many Times. set custom format to mmm but My offset is showing only Jan in Month. and Productivity and Target shows #N/A error
Sir, i practice this worksheet but when I change month to FEB it show Error "#Value"....
There is a problem while changing month formula in to productivity
Time stamp 10:53 mein aapne month Jul select kiya h, but productivity 91 aur target 96 aa raha h....so iss chiz ne confuse kar diya mujhe. Pls thoda samjhaye.
Randbetween use kiya hai isliye valuebchabge ho ra hoga dear
Hello sir I'm getting stuck when I try to make a chart dynamic when I click on target line and edit the target error is coming that excel found a problem with one or more formula references in this workbook tried so many time and when I edit the productivity no error is coming only happen at the time of target editing.kindly give me solution
Copy the data and paste in new sheet then try this make chart,May be this sheet is macro enabled
@@Innozant but sir Im trying in new sheet but the same error is coming
Also sir due to spill function not able to do
Resp sir
Namastey!!!!
Mai video Ko dekha ur custom Wali jagah par utak Raha Hu mujse nhi Ho Raha Please meri madat kijiye pls help by me mai is screen shot ki picture b bhej Raha hu jaha atak Raha hu
Data validation Mai months dikha Raha h apki video mai Ur upper status bar mai date
Mere se ye nhi Ho Raha please madat kare meri
Namastey ke sath apka student
I have done the same thing the way you have show in the above description however i am getting #value error. I have tried with the number format as well however result remain the same in first offset (month)formula.
Kindly watch the video again..you are doing some mistake
Same Problem........ Watched Many Times. My offset is showing only Jan in Month. and Productivity and Target shows #N/A error
Sir i have one confusions, when I try to links months list in this vedio my list not working properly, and could not find this file link , i am your new visitor, kindly help me and send me link of this file personally on my email 🙏
Which file Aarti..?Kindly send your query on mail id-innozantcampus@gmail.com
You are Not Visotor Aarti..You are now a Member of Innozant Family..Happy Learning Dear..Have a wonderful career ahead.
Hi wen i practice for productivity formula showing # NA error
Why..kindly show me your formula
Productivity and Target are not matching with the source data...Error show kar raha hai while selecting month feb,march,apr from drop down...
Drop down me jo month le rahe hain pehle use custom me jaake text function se month banaye wo as a value show ho rha hoga .phir apply kriye formula
@@Innozant kindly check the practice file shared here once...Still getting errors...
Sir ji offset me feb month me error aa raha hai i tried index match and got value
👍❤️
Sir, Unable to see dashboard practice files
Assignment master folder se download kren..link diya hua hai har video ke description me
Offset use karne me Month waale me mera Jan feb dusre rows me bahar aa jata hai aur spill error dene lagta hai,
For Month = OFFSET($A$2,0,0,MATCH(B17,$A$2:$A$13,0),1)
For productivity =OFFSET(Month,0,1)
For Target =OFFSET(Month,0,2),
Kaise Rectify hoga
Kaunsa excel version use kar rhe hain..formula again check kriye
@@Innozant Jha Ji hum Excel 365 use kar rahe hai aur is version me Jaise hi dropdown change karte hai Month ka, offset wale section me month me Month Jan se lekar dropdown k month tak aa jata hai, jo ki Productivity and Target waale offset pe overlap kar jata hai, aur spilling error deta hai, aap email id bhej dejiye, hum aapko apni excel sheet bhej denge
While Practicing this Dash board im getting error
Productivity and Target Getting error #NA I have declarer name range and did as process same as videos still getting error can you please help me to sort the issue
Kindly share your sheet,Will see where you did wrong
sent thru mail please check and let me know .. Please rivert me thru mail or telegram
Sir dynamic dashboard sheet k liye v guide kr dijiye please. I have been commenting since last year but didn't get any reply. Please dhyan dijiye sir
Already dynamic sheet using offset cover kiya gya hai dear
@@Innozant ok sir
Mai video dkhta hu please respond kijiyega sir doubt clear k liye 🙏💝
Sir ji aap video industrial excel aur VBA ke liye bhi banao VBA ke liye kam se kam 6 part banao sir mujhe VBA sheekna hai sir please please please please please please please please please please please please 🙏🙏🙏🙏🙏🙏
Haan dear layenge video...pehle Power series padhte Hain..
@@Innozant thank you sir mujhe aapke lectures bahut acche lagte hai
Thanks
🙏
Thanks
🙏👌
Thanks Arti..Good Night..Happy Learning..❤🙏🙏
Sir i have one confusions, when I try to links months list in this vedio my list not working properly, and could not find this file link , i am your new visitor, kindly help me and send me link of this file personally on my email 🙏
How r u sir
Data Wrong Pick Jaise hi mein Month Change kar raha hu..
Target hai vo formula se aa hi nhi raha hai
Aisa kyu .kya issue aa rha hai aap ek baar excel sheet send kariye @innozantofficial telegram id par
On the belh of sir all are requested please share and like all the videos
Subir das
Happy Learning
Can u please start to telling Hindi as well as English
Planing to add subtitles or start a seprate playlist for English audience
Difficult hai samaj ne me .
Again watch kariye yadi aapne pehle saare concept padh liye hain to aayega samjh easily
कृपया उर्दु ना बोले मुखातिब ये हमारी संस्कृति नहीं है कितने भी बड़े हो जाओ हिंदुत्व जिंदा रखो
Ye channel sirf learning channel hai dear..Keep focus on learning only and keep growing..👍❤️
@@Innozant👍🙏जय माँ kali आप मेरी तरह हो सर जी वा love you
Not Understand this Video Sir
Why Neha.?Recap video again and let me know
@@Innozant Hello Sir,
(1): When I put Offset function front of Month Column… End Enter. Its showing VALUE. Also, when I click on Formula Function in Define Name (MONTH) is not Showing on Top Column.
(2): I Didn’t understand why we Copy and Paste Formula in Define Name.
And sir on which link need to click for obtain RAW DATA for practice for Current video. When i click its open your all classes.
Sir, I really want to say the way you Explain or Present concepts in your videos is very helpful and easy to understand.
sir....... i tried 5-6 time offset formula for productivity where we copy month (offset) formula and paste it as a refference in productivity(offset) but everytime it shows #N\A and literally i am tired by trying many times
@innozant pls reply
Thank you Sir
please sir just give a hint that how can i show only that month chart which one I select. suppose i will select march month the charts will show only march month
One way lookup option
sir I getting trouble when I apply offset formula on month then it automiacally applied on other down cells productivity and target why? a big problem for me rite now ...
Why not you freeze your cell reference of offset
Resp sir
Namastey!!!!
Mai video Ko dekha ur custom Wali jagah par utak Raha Hu mujse nhi Ho Raha Please meri madat kijiye pls help by me mai is screen shot ki picture b bhej Raha hu jaha atak Raha hu
Data validation Mai months dikha Raha h apki video mai Ur upper status bar mai date
Mere se ye nhi Ho Raha please madat kare meri
Namastey ke sath apka student
Kuch Galata kar rahe hain aap dear..phirse video dekhke apply kriye sahi se