I usually don’t comment on RU-vid videos but I have no choice here. As an Excel and Power Query pro myself, I follow quite a few of the top Excel channels. But I just discovered this channel and it is undoubtedly the best. Your explanation is outstanding (for example the video about the new GROUPBY function - I’ve watched many videos on this but you explain it a 100 times better than all of them), your content is unique (like the videos about Structured References), the pace is amazing and it is obvious that you have a commanding knowledge of Excel. Your channel deserves at least 5 million subscribers. You literally dwarf every single Excel channel out there in every metric possible.
You are the best Excel teacher on RU-vid! I am binge watching your videos and learning so many helpful subjects that I have never fully looked into (or seen yet like GROUPBY). Thank you so much for your help!
The puzzling and most hated Excel function: INDIRECT! I've been using it since 2007 I guess, but never understood when to use the quotation marks for cell references, until now. Viewers watch starting @2:30. You are an Excel God!
You're a beginner?! I would've never guessed that. Your presentation and teaching skills are on par with Leila Gharani, operator of XELPLUS. That's probably how the algorithm recommended you to me. I'm blown away. Welcome and thanks! @@bcti-bcti
BCTI, You never disappoint me. This technique is exactly what I've needed for some time, but I assumed I'd need MVP-level "frankenformulas" to get it done. THANK YOU for opening up so many "new" possibilities for my dashboards. Can't wait till these dynamic formulas AND checkboxes are made available to us all.
Awesome ❤ All your videos are awesome and explain the tricky things in excel clearly, elegantly, in-depth and easy to understand. Thank you so much and wait for more 👍👍🌹
INDIRECT isn’t needed for this functionality. INDEX or CHOOSECOLS can be used with a MATCH function returning the column. E.g. CHOOSECOLS(Table1,MATCH([TextToFind],Table1[#Headers],0)). Further, slicers can replace some of the solutions. As always, there are many solutions to a problem in Excel. If this was a video about INDIRECT, then OK … but INDIRECT would not be my recommendation to a client.
Good suggestion. In a pure Office 365 environment, I would totally agree with you. This was meant as a solution that would work with a wider array of Excel versions. Thanks for watching.@@TSSC