+ Reply to Thread
Results 1 to 2 of 2

median function

Hybrid View

flyingmeatball median function 08-17-2006, 11:13 AM
teelim Hi, I am not too sure how... 08-17-2006, 12:58 PM
  1. #1
    Registered User
    Join Date
    08-09-2006
    Posts
    30

    median function

    In Column A I have the ages of a random number of people. I need to take the median of the top 25% of this list. First I sorted the list, and now i need to run Median(A1:AX) Where X is the cell that equals 25% of my total population. My problem is the population(and thus the number of rows used) is constantly changing. How can I put in a value for AX into this equation? Thanks in advance.
    Karl

  2. #2
    Registered User
    Join Date
    07-27-2006
    MS-Off Ver
    MS Office 2007
    Posts
    79
    Hi,

    I am not too sure how exactly you want your data sorted. Hope the file in the following link is what u want (the file is large because the formulas are pasted all the way to the last row)

    Median

    TL

    https://sites.google.com/site/teelim/
    My page of "not so useful" spreadsheets

+ 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