I am working with football stats.

Column A is the player number. Column B is the yards for each play. A
typical sheet could look like:

<Player <Yards
10 21
10 14
10 7
14 1
14 3
10 22
14 11

I have a separate sheet that has each player number in a cell. I need to
find and display the longest yard made by each player.

10 (Longest Yards)
14 (Longest Yards)

Any help would be greatly appreciated!