[Solved] Print list of filtered terms
[Solved] Print list of filtered terms
When I apply Filter to a column I get a dropdown list of all the different terms or values in that column. That's fine. Is there a way to print out this list? I have a spreadsheet with some 35 columns and 7000 rows, and a column with 100+ search terms or descriptors that I would like to print out. Can't find this feature in Tutorials or FAQs.
Last edited by MrProgrammer on Sat Oct 02, 2021 3:43 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
Reason: Tagged ✓ [Solved]
OpenOffice 4.1.3 on Windows8
Re: How to print list of filtered terms
Select the column in question.
Data>Filter>Standard Filter...
[Column A] [<-- not empty -->]
[More Options]
[X] No duplicates
[X] Copy result to cell: X1
[OK]
copies unique values of the selected column to cell X1.
Data>Filter>Standard Filter...
[Column A] [<-- not empty -->]
[More Options]
[X] No duplicates
[X] Copy result to cell: X1
[OK]
copies unique values of the selected column to cell X1.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice