Dynamic Excel Formulas Made Easy - 2 Methods

[@TeachExcel]

MY FULL EXCEL VBA COURSE [35% Discount]: www.teachexcel.com/premium-courses/79/excel-vba-course-beginner-to-expert?src=yt_pinned_comment_Hzt4Xc1JBNY 35% Discount runs until Jan. 26, 2022

[@AndyMartz]

I like the offset function with a counta function or two nested inside.

[@wayneedmondson1065]

Great tips! Thanks for sharing :)) Thumbs up!!

[@TeachExcel]

Thanks! You're very welcome Wayne! :)

[@michaelt312]

I keep forgetting about the INDIRECT function. Great brush up, thank you!!

[@TeachExcel]

You're very welcome!!! Even today, I still find INDIRECT() an amazing tool with older versions of Excel.

[@michaelt312]

@@TeachExcel, even with 365, this can prove useful. You never know what version others will use to open files. And sometimes tried and true is the best.

[@tomaszlitke4303]

Thanks for that one!

[@TeachExcel]

You're most welcome Tomasz!!

[@tha2irtalib343]

Genius ... thanks for sharing.

[@TeachExcel]

You're welcome! I'm glad you like it!!!

[@asimsiddiq475]

thanks again and again.

[@nadermounir8228]

Thank you for this tutorial. Great explanation.

[@TeachExcel]

You're welcome Nader! I'm glad you like it!