CODEWITHSUNDEEP
openoffice.orglibreofficeopenoffice-calc
JeanJouX
JeanJouX

Reputation: 2721

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 ?

Upvotes: 4

Views: 6740

Answers (1)

ngulam
ngulam

Reputation: 1075

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).

Upvotes: 4

Related Questions