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?
|