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/