View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HomeBuyingHQ HomeBuyingHQ is offline
external usenet poster
 
Posts: 1
Default Filtering a List

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 Nice house. Listed with Century 21.
2. $350K
Great house. Call Paul.
3. $320K
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?