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 |