Remove Duplicate rows of having duplicate data in 2 Columns in which 3rd Column status is Completed and Non-Completed using Linq

Currently we could cleanse on only group count = 1 by

dtCleansed =

(From d in dtData.AsEnumerable
Group d by k1=d("Name").toString.Trim, k2=d("Subject").toString.Trim into grp=Group
Where grp.Count = 1
Select r = grp.First()).CopyToDatable

But as you can see in the code we had no logic for Complete presence check included, as we do not see it clearly defined within the description (e.g. do it, handle alternate case like multiple group members, but no completed)

Also have a look here: