View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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)))