MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

========