median...if

[Duritz]

Hi. Like the function "sumif", I need a "medianif" funtion, ie, find the median of a set in column B given that their corresponding figure in A matches a variable.

So, for example:

A B
5 1.2
2 1.4
3 1.4
7 1.2
5 2.3
4 1.6
3 1.5
5 2.2
6 1.1
7 1.9
5 0.9
4 1.9
5 1.7

And if the variable to match is 5, then the figures to find the median of are 1.2, 2.3, 2.2, 0.9 and 1.7, of which of course the median is 1.7.

Any ideas?

 

[mortgageman]

Ok Barry - I tried it. And It clearly worked. I just don't understand why when I tried it with me in a super hero outfit, it did not work!

And don't worry - I did not go to the wrong website and see anything that I was not supposed to see!

Gene, "The Mortgage Man", Klein