List for AutoFilter and list for Subtotals have different meanings? "Epinn" <someone[ at ]example.com.NO_SPAM> 18.08.2006 17:20:36 I need to type up a list if I want to use (1) Date>Filter>AutoFilter or (2) Data>Subtotals A sample list: Month Units Jan 100 Jan 200 Feb 100 Feb 400 Mar 300 etc. etc. I find the following interesting. To do (1) AutoFilter, I have to actually **create** a list i.e. Data>List>Create List ...... If I want to do (2) Subtotals, I **don't** have to do Data>List>Create List ....... If I do, Subtotals on the menu won't even be highlighted. Although both (1) and (2) require a list, the definition of a list appears different. Have I missed anything? Welcome feedback and comments. Please don't ask me to read help because I have done that. I have also watched the AutoFilter demo and actually tried the commands. Thanks for reading and please correct me if I am wrong. I want to analyze and experiment "sort" and "validation" in the data menu at another time so that I don't get too confused right now. But please feel free to voice any comments regarding these two commands in terms of list. Epinn

Re: List for AutoFilter and list for Subtotals have different meanings? gls858 <gls858[ at ]yahoo.com> 18.08.2006 18:25:53 Epinn wrote: [Quoted Text] > I need to type up a list if I want to use > > (1) Date>Filter>AutoFilter or > (2) Data>Subtotals > > A sample list: > > Month Units > Jan 100 > Jan 200 > Feb 100 > Feb 400 > Mar 300 > etc. etc. > > I find the following interesting. > > To do (1) AutoFilter, I have to actually **create** a list i.e. > Data>List>Create List ...... > > If I want to do (2) Subtotals, I **don't** have to do Data>List>Create List > ...... If I do, Subtotals on the menu won't even be highlighted. > > Although both (1) and (2) require a list, the definition of a list appears > different. > > Have I missed anything? Welcome feedback and comments. Please don't ask me > to read help because I have done that. I have also watched the AutoFilter > demo and actually tried the commands. Thanks for reading and please correct > me if I am wrong. I want to analyze and experiment "sort" and "validation" > in the data menu at another time so that I don't get too confused right now. > But please feel free to voice any comments regarding these two commands in > terms of list. > > Epinn > > My auto filter works without having to create a list. Select the entire sheet by clicking in the upper left hand corner of the sheet. Select auto filter. It should place a drop down box at the top of each column. Now you can select a value from the drop down and the sheet will be filtered for that value. gls858

Re: List for AutoFilter and list for Subtotals have different meanings? "Epinn" <someone[ at ]example.com.NO_SPAM> 18.08.2006 20:02:33 Thanks gls858. This is getting more interesting. AutoFilter works regardless of whether I actually do Data>List>Create List, or just highlight a range or select all. Data>Subtotals only seems to work the best when I highlight a range. It **won't work** if I do Data>List>create list. It is not a good idea (although it works) to select all (i.e. choosing the entire sheet) because it will include blank cells, and it can be confusing if one forgets to adjust the entries in the dialogue box. Now, I have to find out when I **must** create a list (Data>List>Create List) before I can apply a command. Comments welcome. Epinn "gls858" <gls858[ at ]yahoo.com> wrote in message news:#tgG#OvwGHA.1272[ at ]TK2MSFTNGP05.phx.gbl... [Quoted Text] > Epinn wrote: > > I need to type up a list if I want to use > > > > (1) Date>Filter>AutoFilter or > > (2) Data>Subtotals > > > > A sample list: > > > > Month Units > > Jan 100 > > Jan 200 > > Feb 100 > > Feb 400 > > Mar 300 > > etc. etc. > > > > I find the following interesting. > > > > To do (1) AutoFilter, I have to actually **create** a list i.e. > > Data>List>Create List ...... > > > > If I want to do (2) Subtotals, I **don't** have to do Data>List>Create List > > ...... If I do, Subtotals on the menu won't even be highlighted. > > > > Although both (1) and (2) require a list, the definition of a list appears > > different. > > > > Have I missed anything? Welcome feedback and comments. Please don't ask me > > to read help because I have done that. I have also watched the AutoFilter > > demo and actually tried the commands. Thanks for reading and please correct > > me if I am wrong. I want to analyze and experiment "sort" and "validation" > > in the data menu at another time so that I don't get too confused right now. > > But please feel free to voice any comments regarding these two commands in > > terms of list. > > > > Epinn > > > > > > My auto filter works without having to create a list. Select the entire > sheet by clicking in the upper left hand corner of the sheet. Select auto > filter. It should place a drop down box at the top of each column. Now you > can select a value from the drop down and the sheet will be filtered for > that value. > > gls858