Hello,

I want to write a formula that calculates the median of a set of values
specified by some criteria. For example, if you have the following in A and B:

1 1
1 2
2 3
1 7
2 6
1 8
1 9
2 4
2 3
2 4
1 5
1 6
2 3

I want to calculate the median of the values in column B that have a 1 in
column A (in this case, median = 6). Does anyone have a good idea for how to
do that?

Thanks,