View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DTTODGG
 
Posts: n/a
Default 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!