Excel 2002/2003 Advanced Filter

[Stevens]

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.

 

[Gary''s Student]

Post more about your requirements. You may be able to use AutoFilter, which
does a good job of filtering in place

 

[ShaneDevenshire]

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.

 

[Stevens]

Shane,

Thank you for the info. I did exactly what you had indicated and all I get
are the column titles. Column M has a title of 'Description'. This column
has many different descriptions in it. I went out to column AM and in row 1
typed 'Description'. In rows 2-4 I entered the 4 descriptions I wanted to
select. I then clicked on column M, row 15 and then clicked Data, Filter,
Advanced Filter. Filter the list, In place is on. The List range is
correct. In the Criteria Range I enter 'AM1:AM5 and click OK. At that point
all it comes back with is my spreadsheet with only column headings.. ???
Any ideas?? The descriptions I typed into AM2:AM4 are spelled exactly as
they are in the Description column. The Description title in the Description
column and the criteria column (AM1) are both exactly the same. I am using
MS Office 2002. I have tried this on a machine with MS Office 2003 with the
same results...

Thanks again.

 

[Stevens]

Shane,

Please disregard my last message. I just found that the description column
title had spaces after the word Description. When I took those out all was
well. Thank you very much for your help.