Returning Index of Last Row that Equals a Certain Value

[rmorgan]

Title is a little long

I need to return the row index of the last row that says “Yes” for instance in the picture it would be the row index of filedITU

[supermanPunch (Arpan)]

Hi @rmorgan ,

Could you maybe try with the below Expression :

rowIndex = DT.Rows.IndexOf(DT.AsEnumerable.Where(Function(x)x("Value").ToString.ToLower.equals("yes")).Last)

Here, rowIndex is of the type Integer and DT is your Datatable variable, assuming Excel sheet is already being read into Datatable

Let us know if this does not work.