Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use AUTOFILTER to update FREQUENCY distribution
I have the following data and have created the FREQUENCY distribution below it.
Ideally, what I want is to be able to see the frequency distribution and use AUTOFILTER on the dates to see the FREQUENCY distribution is for various dates or combinations of dates. However, the frequency distribution doesn't seem to get updated when the autofilter is applied. Ideas and comments welcome! Code:
date category 01/01/2008 1 01/01/2008 1 01/01/2008 2 01/01/2008 4 02/02/2008 1 02/02/2008 2 02/02/2008 3 02/02/2008 3 03/03/2008 2 03/03/2008 4 Freq distribution: cat frequency 1 3 2 3 3 2 4 2 Ideal output when filtered on the a single date Filtered for date: 01/01/2008 cat frequnecy 1 2 2 1 3 0 4 1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Median for frequency distribution | Excel Worksheet Functions | |||
How can i do a frequency distribution by machine automatically? | Excel Worksheet Functions | |||
Frequency distribution | Excel Worksheet Functions | |||
Frequency distribution | Excel Discussion (Misc queries) | |||
Sorting - Frequency distribution. | Excel Discussion (Misc queries) |