+ Reply to Thread
Results 1 to 2 of 2

Post filter median time

  1. #1
    Forum Contributor
    Join Date
    06-20-2007
    Location
    Buckeye, AZ
    MS-Off Ver
    365
    Posts
    272

    Post filter median time

    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
    Attached Files Attached Files
    Last edited by sick stigma; 12-24-2012 at 11:15 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Post filter median time

    See if pivot table can help you.

    See the attached file.
    Attached Files Attached Files
    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • 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