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


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


Use the following array-formula


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.