In this excel file
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
The excel file is attached here : Remove duplicate.xlsx (10.7 KB)
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.