SLW #020: SUM+XLOOKUP
Two exciting things to announce. First, I've upgraded all students who purchased the Excel Analytics OS pack (with 2 digital products) to a "Lifetime Membership." You'll enjoy my new topics and training in the future (if there are any).
Second, I'll be releasing "Masterclass - Creating Insightful Business Dashboards" to membership students next week! You'll learn how to use only "3 functions", no VBA and PivotTable, to build a business dashboard in just 1.5 hours! I hope you'll enjoy it!
For those who want to join, Click this link to enroll now!
I shared this cool trick about SUM+XLOOKUP on LinkedIn a few days ago, and it received a lot of love from my followers.
Basically, I used the array that XLOOKUP provides and added a SUM function to the mix, creating this handy combo I like to call 'SUM+XLOOKUP.'
Dynamic arrays, my friends, are like the superheroes of spreadsheets. They're changing the game and opening up a whole world of possibilities to simplify our daily work.
I'll be exploring more new combinations involving XLOOKUP and new dynamic array functions. Stay tuned for my upcoming posts!
Go watch SUM+XLOOKUP
That's all for this week.
See you next week.
-----------------------------------
Whenever you're ready, this is the way I can help you:
- Digital course: Excel Analytics OS for business professionals
Zero risk, 30-day money back guarantee, no questions asked.