My filter isn't grabbing all the relevant data

I have a data set of ~300,000 rows and 8 columns. I have selected all the data and added a filter.

I filter column C to include the word "restaurant" and it returns a lot of results, but not all of them. It appears that it captures all of the data in the first few thousand rows but then it's only selects a few of the data points from each 5,000 rows ongoing.

I can resort the data based on column d or column e and run the same filter on Column C - it will returns different results.

I need it to display ALL of the data in Column C containing this particular word.

Please help.

No luck. Still does the same thing.
There are also 0 blank rows - I checked that first thing.

I just tried to upload but it said the file was too large.. Is there any other way to upload or share?


Here are the exact 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 resort it, it filters data that doesn't contain the word "fitness" in the industry column.

Brilliant. Data set here: https://www.dropbox.com/s/dwu5u5vk8t...book.xlsx?dl=0

Wanted to see if you had any luck? Thank you!