J
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
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