Finding duplicates of multiple col's and moving

[pauluk]

Hi All,

I am trying to figure out a way to do the following:

Col's A:M are populated but need to be checked for duplicates based on the following:

Find Duplicate in col C for those duplicate check Col E for duplicates if duplicate cut to sheet 2.

A B C D E F G H I J K L M
1)1 1 1 1 1 1 1 1 1 1 1 1 1
2)2 2 2 2 2 2 2 2 2 2 2 2 2
3)1 1 1 1 2 1 1 1 1 1 1 1 1
4)1 1 1 1 1 1 1 1 1 1 1 1 1

Looking at the above then row 4 would be a duplicate and be moved to sheet2

Thanks in advance

[davegugg]

How this work for you:

Please Login or Register  to view this content.

[pauluk]

Hi I have tried the code you published, thanks for this.

However it does not seem to be fully effective?
I alterted it as per below to run as a test but it seems to ID some cells which are not duplicates.

Please Login or Register  to view this content.

[pauluk]

My bad it does work in my tests with your code

Thanks for this your a star