I have Input Table as below picture.
I want to check the duplicate row and delete base on conditions if they same value at A col, B col and any the value at D col = “OK”… then it will delete the first row and keep last row.
The output Table as below:
I have Linq code as below… how to add more the condition if any D Col = “OK”
(From row In Table.AsEnumerable()
Group row By k1= row(0).toString.Trim,k2= row(1).toString Into grp=Group
Let r = grp.last
Order By Array.IndexOf(Table.AsEnumerable.toArray,r)
Thanks in advance!
Book1.xlsx (8.9 KB)