Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
List for AutoFilter and list for Subtotals have different meanings?
I need to type up a list if I want to use
(1) DateFilterAutoFilter or (2) DataSubtotals 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. DataListCreate List ...... If I want to do (2) Subtotals, I **don't** have to do DataListCreate 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
Creating a List based on your choice from Another List | Excel Discussion (Misc queries) | |||
How to link data from one drop-down list to another | Excel Worksheet Functions | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Creating a list from an existing list. | Excel Worksheet Functions |