AutoFilter and Frequency Function

[Jack]

I am trying to see if I can create a frequency function that will
change as I autofilter different criteria.

I have a file with over 15,000 rows returning data on sales
opportunities including key fields I want to filter on: organization,
product line, geography and status (Won, Lost, Open). In each case I
want to see the change in distribution of "days in funnel" whether I
am looking at all the data or just one geography or just one product
line.

It appears that the Frequency function does not recognize the filtered
out data and continues to return values for the entire data set. The
only way I can see to do it is to copy and paste based on the
autofilter and then rerun the frequency function - possible but very
time consuming.

Any suggestion would be appreciated - plus if it cannot be done I
would be just as happy to quit wasting my time trying.

Thanks

 

[AlfD]

Hi!

If you do run Autofilter, try this.

Run a filter.
Select a column by clicking on its header.
Look in the Status Bar where Excel does its running sum/count/averag
etc (I wish I knew a name for it...).

This recognises only the filtered (visible) items.

If you leave the column highlighted and browse around the autofilte
selection arrows and dropdowns, you will continue to get your reading
of count or whatever.

Just one small thing: it counts the column heading as a valid cell, s
you can have two items visibly before you and a count of 3.

Al