Excel filter search removing previous filter selections, MacBook

Copied from a Reddit post, which describes my problem perfectly:

"I have a data set and I want to filter for a series of values in a specific column, say Albert, George, Quellan, and Zelda.

My issue is that when I start filtering by name the filter automatically reverts to "Select All" or "Select All Search Results"

So I will Search "Albert" and select it, then clear the search and the filter will be back on "Select All"

I can search "Albert" and apply the filter, which works for seeing just Albert, but then when I search "George" I run into the same problem. If I search "George" it deselects "Albert"

What works is scrolling through and finding each name manually, but there are many names so this is a bit inefficient.

Does anyone know what is happening here? Is there some setting I can change so that I can just search each name, select it, then end up with all the names selected?"

• https://www.reddit.com/r/excel/comments/sq0oa5/excel_filter_search_removing_previous_filter/?rdt=36084

Does anybody know a solution for this? 

Thanks in advance,

Frederik J.