Excel Magic Trick 1374

Extract Only Total Row: VLOOKUP & Dynamic Range Created by INDEX Function


See how to Create Shrinking and Expanding Range with INDEX function. See how to Get the Total for each employee when the Employee Name column has many empty cells and the “TOTAL” is in a row without an employee name. See how to do this with VLOOKUP & a Dynamic Range Created by INDEX Function.


Download “Excel Magic Trick 1361-1380” Excel-Magic-Trick-1361-1380.zip – Downloaded 558 times – 14 MB

Be the first to comment

Leave a Reply