I've a task as follows:
1) sheet 1: consider duplicates in column 2
2) duplicates in column 2: check if they have different values in column 1
3) if they have different values in column 1, copy entire row in sheet 2.
Look at the example in the attachment:
Beta, Gamma, Ics, Lambda and Omega have duplicates.
But only Gamma and Lambda have different values on column 1, so copy them on sheets 2.
Thank's for your help.