I have a data set of ~250,000 rows and 8 columns. I have selected all the data and added a filter but when I filter by a certain word, it does not return all corresponding values.

Here is the data set: https://www.dropbox.com/s/dwu5u5vk8t...book.xlsx?dl=0

Here are the actual steps I took:

Filter column B with the word "fitness"
Remove it
Sort column F in ascending order
Filter column B with the word "fitness"

An entire different data set appears. I know this because after I filtered it the first time, I applied the word "fitness" to everything in the industry column (less a few specific rows). When I re-sort it, it filters data that doesn't contain the word "fitness" in the industry column.

Here's what I would like to happen:

I would like it to display ALL of the data in Column B containing this particular word.

Please help.