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

Written by kazamraza
no comments

Classified in : Excel Formulas, Lookup Functions

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