Dynamic array charts Integration -Excel(XLOOKUP Bonus)

[@spilledgraphics]

Blood pressure rising up at minute 2:28..... 😵

[@spilledgraphics]

amazing!!! and then on minute 6:58 - woah! goodness!

[@davidakomolafe3609]

Idan movessss🙇🏾

[@abdulsaidmkamara7305]

I Love the Sroll Bar & XMATCH & Take !!

[@ExcelMoments]

How about the Xlookup? 😂 since you love XLOOKUP!!

[@abdulsaidmkamara7305]

@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

[@ExcelMoments]

@@abdulsaidmkamara7305 Confusion is more the word 😁😁

[@abdulsaidmkamara7305]

@@ExcelMoments definitely 😎

[@excelpro365_1]

This is fantabulous. Really helpful. Momoh, you are a guru.

[@ExcelMoments]

You are very much welcome

[@IvanCortinas_ES]

​ 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!!!

[@ExcelMoments]

Thanks for your feedback as always, Ivan

[@spilledgraphics]

@@ExcelMoments Indeed the TAKE function is still now widespread, hope this video helps !! amazing!

[@73p3ro]

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!!!

[@ExcelMoments]

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

[@martyc5674]

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?

[@ExcelMoments]

If you on the beta channel of office 365, then you should have it. The update was from lQ4 2022

[@martyc5674]

@@ExcelMoments ah ok not on beta, but am on current channel(I think it’s called)- so should have it soon

[@waitplanwp4129]

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!

[@ExcelMoments]

Thank you very much! for your kind words always