Sorting/Filtering based on part of cell

[Jwhitehouse]

Hi, and preemptive thanks for any help I get here.

Let's say I have around 25k rows of data, and I need to be able to pull large groups of data based on portions of certain cell. For instance, column 5 of my spreadsheet might read:

Find this one
Don't get this
Find this one
This one is to find
Don't get this
This, find you shall
etc....

And I would need to snag all four records with the word "find" in them. After that, I might need to get all three that have "one" in them. A standard sort or filter doesn't seem to work, as sorts only handle it right if it's the first word, and filter only seems to do total equivalencies.

Anyone got a solution for me? Quick and easy would be nice, but long and arduous works as well.

[NBVC]

Autofilter has Custom option where you can select contains... click drop down arrow and choose Custom.

So you can say "contains" "find" and "contains" "one".

[Jwhitehouse]

I seem to only see:

equal
not equal to
greater than
greater than or equal to
less than

as the five options.

[Jwhitehouse]

Nevermind, I'm quite dumb. I've got it.

Thank you very much!

[NBVC]

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save