Find the Last Row of data in Excel Using INDEX and COUNTA

Written by kazamraza no comments
Classified in : Excel Formulas, Lookup Functions Tags : none

Sometime we have a requirement that we want to fetch data from last cell in a column. This task can be achieve by using

  • INDEX Function (Return the value or reference of the cell at the intersection of particular row and column in a give range)
  • COUNTA Function (Count the number of cell in a range that are not empty)

Read more Find the Last Row of data in Excel Using INDEX and COUNTA