Here is one solution to find "the Reversed Median".
Value One:
=IF(ISODD(COUNT(A1:A6)),INDEX(LARGE(A1:A6,ROW(INDI RECT("1:"&COUNT(A1:A6)))),(COUNT(A1:A6)+1)/2),INDEX(LARGE(A1:A6,ROW(INDIRECT("1:"&COUNT(A1:A6 )))),(COUNT(A1:A6))/2))
Value Two:
=IF(ISODD(COUNT(A1:A6)),"",INDEX(LARGE(A1:A6,ROW(I NDIRECT("1:"&COUNT(A1:A6)))),(COUNT(A1:A6)+2)/2))
Example:
1, 2, 2, 4, 5, 6 -- 2 and 4
1, 2, ,4, 5, 6 -- 4
Hope it helped
Ola Sandström
Attached zip-file:
http://www.excelforum.com/attachment...tid=3648&stc=1
+-------------------------------------------------------------------+
|Filename: Book5.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=3648 |
+-------------------------------------------------------------------+
--
olasa
------------------------------------------------------------------------
olasa's Profile:
http://www.excelforum.com/member.php...o&userid=17760
View this thread:
http://www.excelforum.com/showthread...hreadid=390763