W
wmw
This does not solve it 
My data in the two sheets are not in the same order of cells. e.g A2 i
sheet1 may be duplicate of A325 in sheet2.
I have read the instruction in this website, but I did not know wher
to write the formula,
should it be in a new cell, and does matter if the cells of the tw
ranges are not in the same order?
I mean "does the formula compare cell to cell or range to range"?
Than
My data in the two sheets are not in the same order of cells. e.g A2 i
sheet1 may be duplicate of A325 in sheet2.
I have read the instruction in this website, but I did not know wher
to write the formula,
should it be in a new cell, and does matter if the cells of the tw
ranges are not in the same order?
I mean "does the formula compare cell to cell or range to range"?
Than