P
peteewheat11
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!
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!