Median continued
It should work in the CF without entry with Cntrl-Shift-Enter
HTH,
Bernie
MS Excel MVP
Ah! it works as an array formula!
However, I don't believe ctrl sh enter works in conditional formula ...
"T. Valko" wrote:
=ABS(MEDIAN($A4:$F4)-A4)=MIN(ABS($A4:$F4-MEDIAN($A4:$F4)))
|