Search Multiple Words in a Column

[homebuyinghq]

I download real estate listings for sale into an Excel spreadsheet. I only want for sale by owner listings and do not want listings with a realtor. I have a list of words (Century 21, Prudential, agent, realtor, etc.) that I want to filter the list with so I don't email to those people.

Price Email Description
1. $300K [email protected] Nice house. Listed with Century 21.
2. $350K [email protected] Great house. Call Paul.
3. $320K [email protected] Beautiful house, email Mark, realtor.

For instance, in this list, I am only interested in number 2. Number 1 contains the word "Century 21" and number 3 contains the word "realtor". How can I sort or fiter the list so it only contains number 2?

[rylo]

Hi

Say your data as shown is in the range A4:C7 then

I1:L1 - Description,Description, Description, Description
I2: ="<>*Century 21*"
J2: ="<>*Prudential*"
K2: ="<>*agent*"
L2: ="<>*realtor*"

Highlight the range A4:C7, the data, filter, advancedfilter, OK to make your row 4 the headings (if asked), Criteria Range: I1:L2, Filter in place, and OK.

This should show the 1 relevant entry.

HTH

rylo