Microsoft Excel - Dynamic Structured References

[@evanmoore2141]

You are the best Excel teacher on KZbin! 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!

[@bcti-bcti]

That is an incredibly nice thing to say. I'm honored. Considering some of the Excel KZbinrs I watch, that is VERY high praise. Thanks for watching.

[@Undistinguished-ux9eg]

I usually don’t comment on KZbin 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.

[@bcti-bcti]

That is an incredibly nice thing for you to say. You have made my YEAR!!! Thank you so much for watching!!! 👍👍👍👍👍👍

[@FsoOmar]

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!

[@bcti-bcti]

You are too kind. Thanks for watching.

[@hichamhadj9640]

Too much awesomness in this video, thank you for sharing

[@williamreith1186]

KZbin recommended your site to me a couple of days ago. Your subject matter and teaching skills are incredible. Thank you. BRILLIANT!

[@bcti-bcti]

WOW! This is an incredibly thoughtful comment. As a KZbin beginner, it makes me strive to do even better. Thanks for watching!!

[@williamreith1186]

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

[@hankgrimes1806]

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.

[@bcti-bcti]

I forgot to add the link for the file download. It's in the description now.

[@bcti-bcti]

So glad to hear this will help. Thank you for watching.

[@kebincui]

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 👍👍🌹

[@bcti-bcti]

So sorry. I forgot to add the link for the file download. It's in the description now.

[@bcti-bcti]

Thank you so much for the kind comments. Thank you for watching.

[@dulebarbul]

How can we change the font size in the formula bar to be different (bigger) from the font size in the cells as we saw in your video?

[@bcti-bcti]

Check out my video (link below) to see how this is done. Thanks for watching! kzbin.info/www/bejne/qWaTfGedYpWepJI

[@robbe58]

Again very useful. Great technique. Isn't there any example file available for this video?

[@bcti-bcti]

So sorry. I forgot to add the link for the file download. It's in the description now.

[@yousrymaarouf2931]

Wonderful and unique as usual

[@bcti-bcti]

So sorry. I forgot to add the link for the file download. It's in the description now.

[@bcti-bcti]

Thank you for taking the time to watch.

[@emarcos40]

Thank you for sharing

[@bcti-bcti]

Thank YOU for taking the time to watch.

[@kennethstephani692]

Great video!!

[@bcti-bcti]

Thank you. We appreciate your time and comments.

[@redhaakhund1271]

Excellent 👍👍👍👍👍🙏

[@bcti-bcti]

Thanks for watching. I forgot to add the link for the file download. It's in the description now.

[@alandyer8025]

INDIRECT can be a useful function - but it is VOLATILE and may impact performance - particularly for large workbooks.

[@bcti-bcti]

So very true.

[@TSSC]

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.

[@bcti-bcti]

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

[@FsoOmar]

Please mention the INDIRECT Function in the name of the vid so as to be searchable.

[@bcti-bcti]

"INDIRECT" is in the video tags, so it should come up in a channel search. Thanks for watching.