Hi,

Suppose column C is the column you are interested in filtering on. There
must be a title row! So say C1 contains "Company". Then in an empty area of
the spreadsheet enter the column title "Company", say in cell AM1. In
AM2:AM5 enter 4 company names.

Place your cursor back in the data area and choose the command Data, Filter,
Advances Filter, in the dialog box leave Filter in list, in-place on, make
sure the List range is correct, click in the Criteria range box and select
the range AM1:AM5. Then click OK.

A few key points: You must have one row of titles and the titles in the
Criteria and the Data range MUST be spelled the same, the case does not
matter. Your Criteria range should not include a blank row. Your Criteria
range does not need to include all the titles, if you are not putting
criteria under them. If you want fancier criteria let us know.
--
Cheers,
Shane Devenshire


"Stevens" wrote:

I have an Excel spread sheet with about 33 columns on it. I want to use the
advanced filter to select four items in one of the columns and filter the
list in place. I have looked at the help and tried it, got info off the web
and tried it and nothing seems to work. Either the entire page is blank or
it only shows my criteria. Not sure what I'm doing wrong. Is there anyplace
I can go to find a concise explanation of how to do this. It seems like it
would be simple but it's just not working for me.

Thank you.
--
Mike Stevens