Excel: how to get last row value for two columns

[Manan@MM]

Hello there,

I am working on application where I need to make an excel file which has two columns, one for PASS UUTs and another for FAIL UUTs. For each result of test, i need to make an entry of unit's serial no. in respective columns.

I am using report generation tool-kit which has a function to get last row. However, it is returning value of 'bigger/longer' column. So, can i get last value for each particular column? 

Attached is the excel file for reference.

Thanks,

Manan

[GerdW · Accepted solution]

Hi Manan,

read the sheet until "last row", then search for empty cells (aka elements) in those 2 columns…