I've tried the procedures here
, as well as some more in Excel 2003, 2007 (which has a "delete duplicates" command) and even Oo Calc, but I must be doing something wrong. The duplicate rows just stay there as if I have done nothing. (Excel 2007 reports that xxxx rows have been deleted, but they ...haven't?!) It's a single .xls spreadsheet with 17,000+ rows, and 2 columns.
Thanks in advance for any advice or ideas :-)