Hi,

I have an excel sheet with 15 columns. I want to filter column B, it has over 100 cells for brand names.
For example,
Apple
Apple
Intel
Intel
Nike
Puma
Sony

I have a list of the brand names that I want to keep,
Sony
Intel
Apple

How would I use the filter in excel to filter the original list to only keep the brand names I want. I want it to work like a regular filter in excel where it hides the row of data that I want filtered out.
Thank you for your time.