> On 07:30 Wed 19 Sep , Brian Barker wrote: > > At 21:52 18/09/2007 +0100, Joseph "John" K 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. > > > > I have two suggestions. > > > > <snipped lines> > > > In each case, of course, you would then need to delete duplicate rows > > manually. And again in each case, the marker would disappear from the > other > > duplicate as soon as you deleted one (or all but one) of them. In the > first > > case, if you wanted a double check you could construct a cell somewhere > to > > count the number of instances of "Duplicate!", so that you could be sure > > when you had removed all of them. > > Harold, for some reason I could not get the sheet to sort properly after > applying your formula, even making sure the sort column was formatted as > integer.
After you enter the formula, you would need to copy the column, then paste special (only paste back the values) , since if the formula remains it will report new values each time it is sorted. I have used the suggested method many times and it seems to work. [snip] I agree that the proposed solution of using autofilter is an excellent idea that I'll use myself from now on. /paul -- Processing Key for cracking HD DVD's: 09 F9 11 02 9D 74 E3 5B D8 41 56 C5 63 56 88 C0 ----- Try Torpark; a small portable, open-source, built on Firefox browser that enables anonymous browsing. Requires no installation : http://www.torrify.com/
