Great video! thank you creating/sharing! I am a serious fan of tables, named ranges, and all of the awesome things you can do with them and I think this is a great overview of some of the things you can do with tables.
Hello! Thanks for the feedback! I am somewhat new to GitHub, BUT I put the example files here github.com/Thinkleclt/ExcelCafe Should be public, you need : 05 Advanced Formulas. let me know if that doesn't work Tom
Thank you for creating/sharing this video! Great examples! Index & Match are two of my favorite functions! Although more recently I am using LET, FILTER, and LAMBDA which are a blast to use all together!
Awesome thanks! And beleive me.. it came from experience. I learned the hard way how resource intensive unions CAN be. Let me know if you want to learn about any other database topics
Hello David! Thank you for the feedback! I am building this course out in RU-vid so you get to be along for the ride, buy you are correct! The file is key. I have added it to my teachable site as a free download. Let me know if you have any issues.