Here is a non-array solution:

=SUMPRODUCT(MAX((Sheet1!A2:A12=A1)*Sheet1!B2:B12))

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"peteewheat11" wrote:

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!