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

Help Activities
, ,
1

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.

image

Thanks.

2

@ssb
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

3

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.

4

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
5

@ssb
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
2 Likes
6

Thanks Peter, this is working.

Regards,
ssb

7

@ssb
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

8

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