Formula which uses data from a list with certain identifying codes

[sobrien1234]

I have a huge list. In column A there is a unique code that appears randomly several times. In column b in a number. I want a formula that provides me with the median for that unique code (i.e. without having to autofilter than work it ou manually).

For example:
=median(all numbers on column B that have the same number in column A)

Hope that makes sense?

Thanks!!

 

[Aladin Akyurek]

If D1 houses a unique code, in E1 control+shift+enter, not just enter:

=MEDIAN(IF($A$2:$A$1000=$D1,$B$2:$B$1000))

If you want the calculation to take place in column C, in C2 control+shift+enter, not just enter, and copy down:

=MEDIAN(IF($A$2:$A$1000=$A2,$B$2:$B$1000))

 

[Tetra201]

Or, if your Excel has the AGGREGATE function, try the following normally-entered formula:

=AGGREGATE(17,6,$B$2:$B$1000/($A$2:$A$1000=$A2),2)