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


--
flyingmeatball
------------------------------------------------------------------------
flyingmeatball's Profile: http://www.excelforum.com/member.php...o&userid=37302
View this thread: http://www.excelforum.com/showthread...hreadid=572681

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' (http://www.box.net/public/ug8foz2k7r)

:)


--
teelim


------------------------------------------------------------------------
teelim's Profile: http://www.excelforum.com/member.php...o&userid=36856
View this thread: http://www.excelforum.com/showthread...hreadid=572681