Hi,

Am Sat, 11 Jul 2015 15:29:03 +0100 schrieb stumjumper:

A B C D E
1 Data Data Pts Tm
2 8 Dal 31 BAL
3 19 Pit 19 Pit
4 9 @ATL 15 PHI
5 15 PHI 12 @DEN
6 31 BAL 9 @ATL
7 12 @DEN 9 @ATL Cell e7 should match b9 instead of listing
Atl
8 5 @BUF 8 Dal
9 9 IND 5 @BUF

your sorted points in column D. Then in E2:
=INDEX(B:B,SMALL(IF(A$2:A$10=D2,ROW($2:$10)),COUNT IF(D$2:D2,D2)))
Press CTRL+Shift+Enter to enter the array formula and copy down


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional