Compare 2 columns - new worksheets

[Guest]

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!

 

[vezerid]

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