D
Demosthenes
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,
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,