 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008Data Comparison
Is there a way to compare 2 sheets of data and gets results that lists which records are duplicates and which records are unique? Will this also count the number of duplicate and unique records? Excel 2000  SignatureLPS Do you only want to compare Sheet1 to sheet2 or do you also want to compare sheet2 to sheet1? How do you want the results presented? Do you want unique records colored one color and the duplicates another? Or do you want each group listed somewhere? Where? Or do you want to see a message box telling you the results? Yes, the count of each can be included. HTH Otto > Is there a way to compare 2 sheets of data and gets results that lists > which > records are duplicates and which records are unique? Will this also count > the number of duplicate and unique records? > > Excel 2000
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.