|
|
#2
04-03-2014, 04:04 AM
|
||||
|
||||
Simply use a formula on a third sheet that does a cell-by-cell comparison:
=Sheet1!A1=Sheet2!A1 then copy down & across as far as needed. This will return TRUE for any that are the same and FALSE for any that differ, not just whether the rows are 'new'.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Copy Column setting to other spreadsheets in an excel workbook | officeboy09 | Excel | 5 | 11-05-2013 01:49 AM |
 Can't open spreadsheets
|
kaygeea | Excel | 7 | 10-05-2011 08:00 AM |
|
Odd Excel problem when 2010 spreadsheets
|
uchacker11 | Excel | 1 | 08-01-2011 04:24 AM |
|
Merging two spreadsheets
|
BrazzellMarketing | Excel | 5 | 04-26-2011 01:51 PM |
| PWA, sharepoint links, and spreadsheets | Rkramkowski | Project | 0 | 06-21-2006 01:29 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode