Group: ba.jobs.offered · Group Profile · Search for Appreacite in ba.jobs.offered
Author: peter
Date: Aug 13, 2008 15:27
It's an enormous task in Excel prior to 2007. You can create a copy of your data and then try to use the Remove Duplicates command in 2007. In a quick test it worked with around 60 columns, so it may work on 200 columns, too. If you have MS Access you could import the data to Access, then set the primary key to be all the columns. If there is any row that duplicates any other, Access
|