Finding Median When Data is in Column1 and Label in Column 2
Posted by Biren on October 23, 2001 2:33 PM
Hi,
I have the following type of data:
Amount Payment Method
100 check
10 cash
12 cash
200 credit card
...
...
How do I find the median for Payment Method ? What i want
to do is search in Payment method for 'check' find the corresponding
column value and input that into the median() function somehow.
Is this possible ?
Posted by Aladin Akyurek on October 23, 2001 2:40 PM
Biren,
Use the following array-formula
=MEDIAN(IF(B2:B6="check",A2:A6))
where A2:A6 houses the payment method. You can also put "check" in a cell and use that cell's reference instead of "check" in this formula.
You need to hit CONTROL+SHIFT+ENTER, not just ENTER, at the same time to enter this formula.
Aladin
========
