In the attached workbook, in cell D3, I'm trying to get the median time for AF (C3) using only filtered data.
1. Can median have unlimited data points?
2. If not, how would it work for AVERAGE?
Thanks for the help!
Sick
In the attached workbook, in cell D3, I'm trying to get the median time for AF (C3) using only filtered data.
1. Can median have unlimited data points?
2. If not, how would it work for AVERAGE?
Thanks for the help!
Sick
Last edited by sick stigma; 12-24-2012 at 11:15 PM.
See if pivot table can help you.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks