Thread: filter help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pete pete is offline
external usenet poster
 
Posts: 6
Default filter help

Hello,

I have columns representing company, company's product, and company
street address. all this information is in a row. i have about 800 rows
in my spreadsheet. i want to filter this spreadsheet so it contains
only products that are made by 10 companies or less. that is, i want to
be relatively selective in choosing products that are not made by a lot
of companies, just 10 or less.

how do you suggest i do this in Excel?