Re: Sort rows by keyword

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thank you for your help. I followed the recommended steps however, when the
filteration is complete only the cells that contain the keyword (brand name)
appear. The rest of the cells that don't contain the keyword are not
showing at all. I'm not sure how to retrieve the rest of the cells.

Thank you.

cww



"Oggie Ben Doggie" <oggie.ben.doggie@xxxxxxxxx> wrote in message
news:1151355786.121927.9600@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
You could use an autofilter on the column... if it sounds basic its
only because I don't know how familiar you are with Autofiltering...

Click the column heading above the descriptions.
Click Data, choose Filter, choose Autofilter. It'll put a dropdown at
the top of the column(s) selected.
Click it and scroll to down choose "custom..."
Click the dropdown under "Show rows where:" and choose contains
In the text box beside, type Windmill or a part of the word Windmill,
This'll filter the list based on the criteria "show rows where
description contains windmill". You can click the dropdown at the top
of the column again to sort Ascending or descending...

I don't know if that helps, warm regards.

Ben


cww wrote:
In Excel 2000, I have a list of products that I wish to sort by brand
name.
However, the brand name can be located anywhere in the product
description.

For Example:
ADULT CHEWABLE MULTI-VITAMIN WAFER 60 WF - From WINDMILL

WINDMILL would be the brand name.

Each brand name has approx. 200 products; and I have approx. 30 brand
names.

Any assitance would be very much appreciated. Thank you in advance.

cww.



.

Relevant Pages

  • Re: Sort rows by keyword
    ... cww wrote: ... Click Data, choose Filter, choose Autofilter. ... In the text box beside, type Windmill or a part of the word Windmill, ... WINDMILL would be the brand name. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: So whats wrong with the Airhog filters? was:Re: Airhog filters almost free after Frams rebate
    ... control of the "facts" presented therein a recommendation would serve ... to one and all that brand XX is the best filter while brand YY is the ...
    (rec.autos.tech)
  • Re: Whats wrong with Duracell Alkalines?
    ... >> works just fine with Maxell brand. ... > in the battery holder. ... > take maxells cells. ...
    (sci.chem.electrochem.battery)
  • Re: Making Excel act like a database.
    ... The spreadsheets analyze our performance for them. ... These spreadsheets follow a very specific formatting that the clients ... copy and paste to get the data in the right cells. ... Feb Brand X 9 $2,740.36 ...
    (microsoft.public.excel)
  • Re: Which oil filters are best?
    ... Another brand I ... Suggesting that a Wally World filter - provided by the absolute lowest ... I have compared Bosch gas filters that way. ... The absolute BEST story like that I heard came from a friend who was working on a BMW 5-series, ...
    (rec.autos.tech)