View Single Post
  #3   Report Post  
Harlan Grove
 
Posts: n/a
Default

Henrik wrote...
Is it possible to submit the MEDIAN() function as an array (ctrl + shift +
enter)?

....

Yes.

However, when I submit

{=MEDIAN(IF(("a"=$A$1:$A$7),$B$1:$B$7,))}

it does not give me the intended result.


Since these are fairly short arrays, what's in A1:B7, what result do
you get, and what result were you expecting?