在Excel中使用MEDIAN IF函数作为索引?
So I have my Median If function as
=MEDIAN(IF($A$6:$A$200=$L$5,D6:D200))
and I want to know if I can wrap this in an INDEX function to return a value on the row of the calculated median, but in a different column (probably using MATCH I guess)? I've looke...