How to Remove Duplicates on an Open Office Calculator

Calculators are term for OpenOffice.org Calc spreadsheets that allow you to tally calculations related to practical concerns such business profits, retirement savings, yearly budgets and mortgage payments. Duplicate entries within any of the aforementioned types of spreadsheets, or any spreadsheet for that matter, will generate grievous errors that destroy the accuracy of this application's calculations. Prevention of duplicate entries through concentrated effort is the best weapon of defense against mistakes. But when your fingers fail you, checking for duplicate values in OpenOffice Calc and deleting or correcting them will restore the accuracy of your work.

Instructions

1. Click the first cell of column A and drag the cursor downward until all of the column's data is selected.

2. Sort the selected data range by choosing "Data" and "Sort" from the main menu then click "Ok."

3. Look for duplicates in the the same column by examining its new, ascending order.

4. Click and drag to sort each of the other columns individually, so that their values also all appear in ascending order.

5. Compare each of the sorted rows and look for duplicates.

6. Click within the cell that contains a duplicate value.

7. Press the Delete key or enter a correct value.

Tips & Warnings

• Remove duplicates with this manual technique as this software isn't capable of identifying which duplicate should be deleted.

References

• OpenOffice.org: Templates
• OpenOffice.org: Documentation: How Tos: Removing Duplicate Rows