Getting the mode from a varied list

[smiths87]

Hey,
For some reason I'm not seeing how to do this, but I think it will probably be easy for a multitude of you. I have a list in column A of identifier numbers, and a corresponding price in column B. I need to extract the mode of each identifier's price.

111 $2.50
222 $3.00
333 $2.65
333 $2.65
333 $2.72
444 $1.50
444 $1.50

So I take the list in column A, copy it somewhere else and remove duplicates, and when I put a formula off to the side for 333, I want the return value to be 2.65. Just can't quite rap my head around how to do it at the moment. Any help is appreciated, thanks.

 

[mikerickson]

You could use this CSE formula
=MODE(IF(A1:A7=333,B1:B7))

entered with Ctrl-Shift-Enter (Cmd+Return for Mac)

 

[smiths87]

Thanks Mike, that is exactly what I was looking for.