Remove rows that are duplicate and multiple of 2

In this excel file image
if i want to remove all the rows which have duplicate “Actual Work” and “Pending Work” in a set of 2(i.e. if 2 rows are duplicate then remove one of them, if 3 rows are duplicate then remove 1 of them, if 4 or 5 rows are duplicate then remove 2 of them, if 6 or 7 rows are duplicate then remove 3 of them and so on).

The Output File looks like image
The excel file is attached here : Remove duplicate.xlsx (10.7 KB)

Please help.

Hi @Soniya215

check below post

Hope this helps


1 Like

Thanks @Srini84 but this solution will delete all my duplicate rows whereas i want to remove rows which is multiple of 2 (in row count) like every 2 or (2 or 4) or (2 or 4 or 6)

have a look on this demo XAML:
Remove duplicate.xlsx (10.6 KB)
Sonia215_RemoveMulti2Dups.xaml (6.6 KB)

Same as usually: for production level feel free to do some enhancements (e.g. no row return check)
Kindly note: the order in the output maybe differs, but the result should be as expected


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