Best way to build a PivotChart ever. Standard Victor Momoh!!! You break me when you claim; How to make? And answer; ...very simple... My level in Excel that was on the scale of 00 to 10 at level 2.9 decreases to 0.9!!!
Hahahaha, now you are being too modest!! 0.9/10? A big thanks for the compliment. Just the simple building blocks that can make you a magician overnight
@ExcelMoments I love it 😀 but it wasn't new to me since I saw that Technique from one of Oz's Video's which he credited to you ... I appreciated the Take and Xmatch because as you know being a child of Dynamic arrays I never knew how to use index or match so I am slowly warming up to them even though I know you used the (X) MATCH just to add glitter 🤣😂 or confusion
191 / 5.000 Excellent methods Victor. The use of the TAKE function is not widespread, so the explanation is very welcome. The method with XLOOKUP creating a dynamic range is very brilliant. Thank you!!!
Top video as always Victor - and you got to mention at least once that Xlookup returns a reference!!- anyone know what excel version the spilled array/chart started working together?
Stunning video Victor as always, it's just fun to see the genius in action.
Keep surprising me all the time with your brilliant ideas!
Thank you very much! for your kind words always
Best way to build a PivotChart ever.
Standard Victor Momoh!!!
You break me when you claim; How to make? And answer; ...very simple...
My level in Excel that was on the scale of 00 to 10 at level 2.9 decreases to 0.9!!!
Hahahaha, now you are being too modest!! 0.9/10? A big thanks for the compliment. Just the simple building blocks that can make you a magician overnight
Idan movessss🙇🏾
This is fantabulous. Really helpful. Momoh, you are a guru.
You are very much welcome
I Love the Sroll Bar & XMATCH & Take !!
How about the Xlookup? 😂 since you love XLOOKUP!!
@ExcelMoments I love it 😀 but it wasn't new to me since I saw that Technique from one of Oz's Video's which he credited to you ... I appreciated the Take and Xmatch because as you know being a child of Dynamic arrays I never knew how to use index or match so I am slowly warming up to them even though I know you used the (X) MATCH just to add glitter 🤣😂 or confusion
@@abdulsaidmkamara7305 Confusion is more the word 😁😁
@@ExcelMoments definitely 😎
191 / 5.000
Excellent methods Victor. The use of the TAKE function is not widespread, so the explanation is very welcome.
The method with XLOOKUP creating a dynamic range is very brilliant. Thank you!!!
Thanks for your feedback as always, Ivan
@@ExcelMoments Indeed the TAKE function is still now widespread, hope this video helps !! amazing!
Top video as always Victor - and you got to mention at least once that Xlookup returns a reference!!- anyone know what excel version the spilled array/chart started working together?
If you on the beta channel of office 365, then you should have it. The update was from lQ4 2022
@@ExcelMoments ah ok not on beta, but am on current channel(I think it’s called)- so should have it soon
Blood pressure rising up at minute 2:28..... 😵
amazing!!! and then on minute 6:58 - woah! goodness!