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)

=MEDIAN(IF(A1:A1000=A2,B1:B1000))

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.

       --A--- --B-- --C---
   1   Part # Units median
   2    72663   102     97
   3    72663    51     97
   4    72663   175     97
   5    72663   158     97
   6    72663    22     97
   7    72663     8     97
   8    72663   227     97
   9    72663    97     97
  10    72663   414     97
  11    72663   251     97
  12    72663    48     97
  13    72663   113     97
  14    72663     3     97
  15    72663     3     97
  16    72663     4     97
  17    72734   144    316
  18    72734   186    316
  19    72734   251    316
  20    72734    21    316
  21    72734   190    316
  22    72734   138    316

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)

=MEDIAN(IF(A1:A1000=A2,B1:B1000))

ALSO returns 97.

What am I missing?