Showing posts with label Excel 2003. Show all posts
Showing posts with label Excel 2003. Show all posts

Removing Duplicate Rows in OpenOffice.Org Calc or Excell

How to remove duplicate rows from OpenOffice.org Calc or Excel

Q: How do I select all unique values from a column in an OOo Calc/Excel spreadsheet?
I want to remove all duplicate rows from an OOo Calc/Excel spreadsheet with a HUGE amount of rows.

Before you do anything I recommend you save copy of the file with a different name so that you have something to go back to in case something goes wrong.