How to move data from one sheet to another
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
|