For Each Row Excel Same contain column

[anh.nguyen]

Hello,

I have 1file excel to read and type in to app. Because every row excel I have to find Col(No) and choose Col(TimetoWork) and type into Col(OverTime). IF same 1person but i waste time for action Find Col(No).

As you see we have same content at Col(No) how i just find 1time Col(No) ? and repeat action Find when have new Col(No)

[Sanjit_Pal]

Hey @anh.nguyen,

Use datatable.DefaultView.ToTable(True,“Col(No)”,“Col(TimetoWork)”).
This will return you the unique value based on the two column you won’t get the repeated rows.

Thanks,
Sanjit

[Yoichi]

Hi,

We can achieve it to keep previous number and compare it with current number as the following

Sample20220509-1.zip (9.6 KB)

Regards,

[anh.nguyen]

Thank you so much it run ok