## Find the Last Row of data in Excel

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

Excel formula

```
=MATCH(REPT("z",255),MyRange)
```

In the following example in Column A, the last cell number containing data is 14. We can use INDEX Function to get last cell value

◢ | A | B | C | D | E |
---|---|---|---|---|---|

1 | Data |
Formula, Get Last Row # With Data |
Result, Last Row # |
Formula, Get Last Row Data |
Last Cell Value |

2 | RAZIA BEEGUM W/o JAVAID MASIH | =MATCH(REPT("z",255),A:A) | 14 | =INDEX(A:A,C2) | ARIFA BIBI W/o FAZAL ABBAS |

3 | RAZIA ASIF W/o ASIF ALI | ||||

4 | SUMERA FAROOQ W/o FAROOQ RAFIQUE | ||||

5 | ZUMURD BIBI W/o MOHAMMAD BASHIR | ||||

6 | FOZIA BIBI W/o ASHRAF HUSSAIN | ||||

7 | SHAHEEN ARSHAD W/o MUHAMMAD ARSHAD | ||||

8 | NAZIA ABID W/o ABID HUSSAIN | ||||

9 | ISHRAT ASIF W/o ASIF ALI | ||||

10 | JOTI D/o IRFAN JAVED | ||||

11 | SANA SHABBIR W/o SHABBIR AHMAD | ||||

12 | SOBIA ASLAM W/o MUHAMMAD ASLAM | ||||

13 | KHALIDA PARVEEN W/o MUHAMMAD ISHAQ | ||||

14 | ARIFA BIBI W/o FAZAL ABBAS | ||||

15 | |||||

16 | |||||

17 | |||||

18 | |||||

19 | |||||

20 |