How to filter column base on another list?

[yannipr]

Hi
How to filter column base on another list?
For example, how to filter column C "Rep" base on the list in spreadsheet "filter list" ?

Please see the attach file

Thank You!

[Glenn Kennedy]

...and what data do you want to see on the sheet "filter list"?

[yannipr]

In the "filter list" nothing should be changed,

In the "Master" spreadsheet I need to see only the lines that contain the words:

Morgan, Jones, Gill, Thompson

As the another example attached "example.result.xlsx"

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[yannipr]

Thank You!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.