Given a sheet of about 2000 rows with the first column containing numbers sorted into ascending order but with the same number sometimes appearing in more than one row, what is the easiest way to remove rows with the duplicated numbers leaving only one instance of each number. Columns 2 onwards may differ row to row even if the cell in column 1 is the same. I've tried all sorts of ways to do this but seem to end up with something far too complex.
Am I missing something obvious? I would have thought this was a fairly common requirement. Regards, John -- It is often safer to be in chains than to be free. Joseph K --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
