A changing frequency table
As you all know, the Aggregate Function can be used to filter out certain data that you may not wish to see in certain calculations.
Unfortunately, the Aggregate Function does not include Frequency.
Does anyone know of a way to create a Frequency Table in Excel that will change according to the filtered data?
For example, let say that I use the aggregate function to calculate the mean for a time difference data set.
Now, let's say that I want to eliminate 0:00:00 from the Mean Calculation.
I can unclick 0:00:00 from the filter and the Mean will be adjusted with the aggregate function.
However, if I am using the frequency function, the 0:00:00 will continue to be included with the Freq calculation.
Does anyone know of a clever, automated way to adjust for the data I want filtered out in Frequency Calculations?
Thank you for your help with this!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By George.ca in forum Excel Formulas & Functions
Last Post: 04-03-2014, 03:23 PM
By tessda in forum Excel General
Last Post: 07-02-2012, 01:25 AM
By joshuar in forum Excel - New Users/Basics
Last Post: 12-20-2011, 12:52 PM
By Nopperson in forum Excel Programming / VBA / Macros
Last Post: 02-08-2011, 06:57 AM
By xianwinwin in forum Excel General
Last Post: 06-22-2010, 03:17 AM
By ryue65 in forum Excel General
Last Post: 12-10-2009, 04:50 PM
By dude_dude_dude in forum Excel Formulas & Functions
Last Post: 05-21-2008, 02:44 PM
Tags for this Thread
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1