View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bony Pony[_2_] Bony Pony[_2_] is offline
external usenet poster
 
Posts: 71
Default Interesting Median observation

Am I going crazy?

Create 16 values so that the formula
=median(a1:a16)

does not return the value of an actual cell you have typed.

Now use
=median(a1:a16,1)

and it gives you the cell in your range that is closest (lower range) to the
median!

Can anyone explain this?

Regards,
Bony