What is the best way to select a row with that a column consists a certain value in Excel

Hi All,

I am facing an issue while extracting data from excel sheet. I want to select the last row data based on a particular column value. From the attached image, I want to copy the highlighted row details. Please can you help on this.



Welcome to the forum
From the yellow marks we cannot derive a rule for selection
15 (row8) is marked but not the latest one (vs. Row11)

Maybe you share some more requirements of your case with us. Thanks

Hi Peter,
Thanks for the response and here my question is, “Column A” consists multiple data. So I want to get data for last row details of each based on Column A.

ok, got it.
We can do it with a group by on column A and retrieiving the last group member

For more details get introduced here:

1 Like

give a try on following

Assign activity
Left side: dtFiltered | datatype: DataTable
Right side:

(From d in YourDataTableVar.AsEnumerable
Group d by k=d(0).toString.Trim into grp=Group
Select r=grp.Last()).CopyToDataTable

Thanks Peter, this is working.


Perfect. Just do your final testing and please mark the solving post as solution or let us know your further open questions. So others can benefit from it. Thanks

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.