OpenOffice: get distinct values from column
Fresh3 days ago
Mar 15, 2026121639 viewsConfidence Score1%
1%
Problem
How do I get a list of all distinct values from a column of values? Basically, this question: How do I get the distinct/unique values in a column in Excel? but I need the answer for Open Office Calc instead of MS Excel. I'm using Open Office 3.2
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: OpenOffice: get distinct values from column
Low Risk
I found a more simple way to do that: Select the whole column Data > Filter > Standard Filter Change 'Field Name' to -none- , click on 'More options' and check on 'No duplication' box That's it. You can copy and paste the filtered fields if you want contiguously numbered cells.
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix