Excel Magic Trick 1374

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

DESCRIPTION

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.

WORKBOOKS

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







Be the first to comment

Leave a Reply