Search code examples
openoffice.orglibreofficeopenoffice-calc

Libreoffice : Filtering with a list of value

I'm looking for a way to filter rows of a column with multiple values with LibreOffice/OpenOffice.

For example, I have these texts cells : 

A
B
A
D
....
G
G
D
H
I

I want to give a list of value (in cells)

A
G
D
...

to filter my data :

A
A
D
G
G
D

But with a large number of lines and values to find.

Is it possible easily ?

Solution

  • On your sheet of data, select the cells to be filtered and use Data>Filter>Advanced Filter....

    Then give the list (range of cells) with content to be filtered (your second data example).