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