You saved my day! Big thank you for sharing knowledge
@sassydoxie
Жыл бұрын
Exactly what I have been looking for to use in my HR Metrics Dashboard and not using slicers but a drop down menu. Thank you! Easy video to follow!
@LotfyKozman
6 жыл бұрын
Wow, what a wonderful technique, you could employ each easy friendly function to be merged together to create something new, in another way; creating something from nothing. Thanks so much for your kind efforts
@VijayKumar-zd7ou
3 жыл бұрын
Respected sir, I see this video before you upload in ur channel but I need this switching situation after 2 years. Thanx for helping us 😊❤️ Regards Vijay
@Officeinstructor
3 жыл бұрын
Most welcome
@izzat_kiswani
2 жыл бұрын
Amazing!!!
@ToanLam
6 жыл бұрын
amazing technique, learn a lot from you. Thank you
@Officeinstructor
6 жыл бұрын
Thank you for the nice comment
@mayuriank9475
2 жыл бұрын
Thank you very much sir for the neat explanation, it worked fabulously.
@Abdelkebir12
5 жыл бұрын
Mach'Allah, you are so great brother Nabil. Keep going!
@Officeinstructor
5 жыл бұрын
Thank you
@katerinarag16
3 жыл бұрын
Hello! Thank you so much for this video, it was really helpful! Just wanted to let you know that when using the formula =indirect(vlookup(switching!....)) the excel finds an error and does not accept it. Instead I used the same formula as the vlookup (previous step) without using the word “switching” and worked just fine. I leave this comment in case anyone experiences the same problem as me. Thanks again!!
@betaloop8166
3 жыл бұрын
Yes, the sheet name is "Switch," and the similar Defined Name "Switching" was accidentally typed. He went pretty fast through that part. I love the results, though, and hope he'll get around to a follow-up.
@hankgrimes1806
5 жыл бұрын
Excellent!
@Officeinstructor
5 жыл бұрын
Thank you
@mirrrvelll5164
4 жыл бұрын
Splendid video! This is like Camera tool option; I mean from the principle.
@Officeinstructor
4 жыл бұрын
Indeed it is!
@piyushjain009
3 жыл бұрын
@@Officeinstructor at last while adding switching in the formula bar it is showing reference is not valid
@Officeinstructor
3 жыл бұрын
@@piyushjain009 Note that you Must precede the cell reference with the worksheet name when defining names
@rtvoii2
3 жыл бұрын
Fantastic! Thank you!
@Officeinstructor
3 жыл бұрын
You're very welcome!
@piarchanddogra1659
4 жыл бұрын
Excellent 👍👍 Thanks for sharing..
@muralikrishnaa6995
2 жыл бұрын
Hello , Thank you very much for the solution. it is very easy & great.
@l.khalid5394
4 жыл бұрын
It's fantastic technic...tks!
@Officeinstructor
4 жыл бұрын
Glad you like it!
@paulngugi3074
4 жыл бұрын
This is excellent
@Officeinstructor
4 жыл бұрын
Thank you
@bunty300981
6 жыл бұрын
Superb !!
@Balwan_Singh
4 жыл бұрын
Your are brilliant
@Officeinstructor
4 жыл бұрын
Thank you
@Angexcel
5 жыл бұрын
Excelent Mr Nail.
@only4technical722
5 жыл бұрын
Wow wonderful this videos sir....
@garciarogerio6327
2 жыл бұрын
Great
@rizwanamath8761
3 жыл бұрын
Hi Bro. I have a small issue when am trying to switch the table as you mentioned after your final step always pop in this message. Reference isn't valid. Still i could not overcome with this. would appreciate if you could help me out.
@Barchafel
4 жыл бұрын
Hello sir. Do u have the video where we put the charts in a dashboard. Thank u
@VijayKumar-zd7ou
3 жыл бұрын
Simple way dear everything is show in this video
@rishisaha299
4 жыл бұрын
Hi, Thanks a lot for this instructive video. It seriously helped me a lot. Could you please elaborate how I can transfer this to my dashboard once I am done?
@Officeinstructor
4 жыл бұрын
Will try to do that shortly
@piyushjain009
3 жыл бұрын
At last when I am adding switching in the formula bar it is showing reference is invalid
@angela4598
3 жыл бұрын
=Indirect(VLOOKUP(Switch *either remove the word "Switch" or rename it same with the name of your sheet name*
@shazja25
2 жыл бұрын
@@angela4598 still invalid :(
@bobbydhanapal
Жыл бұрын
Brother. I created as same by step by step. But switching only one year and table is changing ...the remaining 3 yr is not reflecting wile switching ..how to solve this ?
@shoppersdream
3 жыл бұрын
Thank you! This is beautiful but surely there is a little issue. When we change the name from range to Switching. We can change from one chart to another but if I choose Source Table, It will show you the last chart you chose. It does not show you just the Source Table. Is this the way it should behave? Thanks
@arshisheriff
4 жыл бұрын
If I want to display the dropdown box and the linked chart on a PowerPoint presentation so that I can choose the required chart and it will dynamically change on the ppt, how do I do that?
@Officeinstructor
4 жыл бұрын
I do have a video on creating a Pivot Table in Excel and modify it in PPT. You'll find it in my channel
Пікірлер: 49