When using Open Office Calc to create sequential lists, you may want to eliminate duplicates. While it's not as fast and easy as MS Excel, you can do it quite easily.
Follow the guide below to find out how.
Step

Step 1. Enter the list you want to filter using Open Office Calc

Step 2. Select the data to be filtered
After that, go to Data >> Filter >> Standard Filter.

Step 3. Click More Options
This will redirect you to the advanced options.

Step 4. Click No Duplicates
Change the Field Name to “none”. If you want to create a separate list, click Copy To… then select a cell address; for example, B1.

Step 5. Select Ok
You will be redirected back to the listing page and the duplicates will be gone.