One thing you might try, it to CONCATENATE the Product and Company names into
a helper column, then Autofilter on that column for the "Botom
10".........maybe that would give you what you're after.......

Vaya con Dios,
Chuck, CABGx3



"pete" wrote:

hi,

i figured i would use Advanced Filter Criteria, but i'm not sure what
Excel syntax/functions are available for filtering a column of nominal
data based on the number of occurrences of a token.

for example, if i have a list of criteria (a column vector with
elements/tokens representing products)

Videogame
Joystick
PowerGlove

and a range of other products (800+), i want to get the row
representing the company, product, address only of those products that
are made by 10 companies or less. essentially, i want to study the
niche markets and products.

thanks,

pete


CLR wrote:
Probably your best bet would be to use the Data Filter AdvancedFilter......

Vaya con Dios,
Chuck, CABGx3




"pete" wrote:

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?