Filter not returning all relevant results

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.

Here's what I used to filter column B and can't say the sort makes any difference.

Please Login or Register  to view this content.

if you have excel 2013

just click the filter arrow on top of the cell and type the word

and it should filter and show every cell with that word

or go to custome filter and select contains and write the word and it should find the cells