finding median with criteria

how would I find the median of a group of numbers? I have a database with a group of numbers associated with a part number. I need to find the median of each part. Here is what I have tried, but it doesnt work
=MEDIAN(IF(A:A=A2,B:B))

please help
thanks

Try this ARRAY FORMULA, which is committed with CTRL+SHIFT+ENTER
(instead of just ENTER)

Please Login or Register  to view this content.

Is that something you can work with?

Worked fine for me. In C2, array-enter =MEDIAN(IF($A$1:$A$1000 = A2, $B$1:$B$1000)) and copy down.

Please Login or Register  to view this content.

Using your posted workbook
...and...assuming the median value for B2:B16 is 97
as calculated by: =MEDIAN(B2:B16)
Then this ARRAY FORMULA (committed with CTRL+SHIFT+ENTER)

Please Login or Register  to view this content.

ALSO returns 97.

What am I missing?