I am trying to find a way to filter rows based on something within a cell. For example, I would like to be able to filter the following so Excel showes me only the people who live on main st (regardless of the street number).

number address name
1 123 main st bob
2 123 elm ave joe
3 123 1st john
4 456 1st betty
5 456 main st susan
6 456 elm ave zach