Delete duplicate rows in Excel?

Vion · 2 · 1024

Vion

  • Sr. Member
  • ****
    • Posts: 630
    • Gender:Male
  • Creative, Hardworking and Able!
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 :-)


spiros

  • Administrator
  • Hero Member
  • *****
    • Posts: 811551
    • Gender:Male
  • point d’amour


 

Search Tools