Those are awfully complex formulas for a simple calculation. Why not
=LARGE(A1:A6,COUNT(A1:A6)/2)
for the median (if n odd) or the larger middle value (if n even), and
=IF(ISEVEN(COUNT($A$1:$A$6)),SMALL($A$1:$A$6,COUNT ($A$1:$A$6)/2),"")
for the smaller middle value (if n even)

Jerry

olasa wrote:

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