Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2002/2003 Advanced Filter
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 |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2002/2003 Advanced Filter
Post more about your requirements. You may be able to use AutoFilter, which
does a good job of filtering in place -- Gary''s Student - gsnu200726 |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2002/2003 Advanced Filter
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 |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2002/2003 Advanced Filter
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. -- Mike Stevens "ShaneDevenshire" wrote: 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 |
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2002/2003 Advanced Filter
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. -- Mike Stevens "ShaneDevenshire" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to clear advanced filter in excel | Excel Discussion (Misc queries) | |||
using advanced filter in excel | Excel Discussion (Misc queries) | |||
Excel crashes when I do an Advanced Filter? | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
Can Excel advanced filter be used in "and NOT" mode | Excel Worksheet Functions |