Can you use the MAX function in Excel to find the largest value across all worksheets? You can use a 3-D Reference or a spearing formula. In this episode, I will show you an easier way to create 3D References in Excel.
Also, a trick from Mack Wilk for making your 3D Reference go through a blank sheet at the end.
For more information about the book, MrExcel 2021 Unmasking Excel, visit: https://www.mrexcel.com/products/mrexcel-2021-unmasking-excel/
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64