Compare 2 columns - new worksheets
 

Hello-

I have a very large spreadsheet.
I have created 2 new worksheets within this workbook - SAME and DIFF
I would like to compare columns E and F in worksheet RAW,
if E=F, then take the whole row (format and all) and copy to SAME
if E<F, then take the whole row (format and all) and copy to DIFF

Thank you so much!

Compare 2 columns - new worksheets
 

Use a helper column, adjacent to the data, with the formula =E:E=F:F
throughout the column. Then use Data|Filter|Autofilter. Filter on the
helper column first for TRUE and then for FALSE.

In both cases use Edit|Go To...|Special...|Visible cells only. Copy and
paste accordingly.

HTH
Kostis Vezerides