The Advanced tab is good, but I don't have office 2013, I have office 2007

I want to move the duplicate values
in sheet 2
but to keep the values that are single sheet 1


I want to move cut/paste all values duplicates from sheet1,
in sheet2

in sheet 1 to remain only the values themselves which didn't pair
I mean if a value is 2 times
to move the original value
but and double found

file attachment is as example

Attached Files

maxim.xlsx (11.3 KB, 10 views)