Finding the median

[pickslides]

Well I know how to find the median for a list of numbers using =median()

But what if I have a list of prices for different types of say cars.


Car Type Price

A $10000
B $15000
A $20000
C $30000


Is there a macro that will return


Car Type Median
A $
B $
C $

[Paul]

Hi Pickslides, try the array formula:

=MEDIAN(IF(A1:A4="A",B1:B4))

Where A1:A4 have your car types, and B1:B4 your values. You could use the static value "A" as the car type, or refer to a cell that has the A in it, too.

As with all array formulas, you must press CTRL+SHIFT+ENTER after typing or editing the formula, not just ENTER.

[pickslides]

Thanks Paul

Great solution.

I am really enjoying these array formulas of late.