On 11:07 Wed 19 Sep , Rick Knight wrote: >> On 18/09/2007 21:52, JosephK wrote: >>> 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 >>> > Try the Standard Filter under Data. It has a checkbox for No Duplication. > I've been using this for a couple of years now and it has never failed me. > For an example, look here Filter Unique Values in OOo Calc > <http://markjstevens.net/index.php>. > > Rick >
Ah! Exactly what I was looking for and couldn't see. Thank you. I use the AutoFilter every day and have looked at the Standard Filter but never clicked on the More button. 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]
