Capabilities of Text Filter - By Specific Character

[lsbraun]

Hi All,

(Using Excel 2010)

I'm trying to develop a way to filter rows by a column containing the bus routes connecting to a given stop.

Said column is a string of comma separated numbers, examples would include:

1
1,7,10
5, 10, 21

For this example, the goal is to filter down to all rows containing route 1. The challenge lies in omitting route 10, 21, etc.

Is there a way to have the text filter only apply to "1"?

I'm fairly new to VBA, but open to code-based solutions as well.

Any insight is greatly appreciated!

Thanks,
Lucas

[dflak]

This works, assuming the stops are in column A and the routes are in column B.