I am not completely sure how to put the formula together.
If the cells are listed like this (All on the same sheet)

+....A........B..............C.............D
1....Rank..Stores.....YTD.........
2....1........Blank.......Athens....2
3....2........Blank.......Baytown..1
4....3........Blank.......Hugo.......2.5
5....4........Blank.......Walden....3.5


How would I put the formula..

=IF(ISNA(RANK(x!C3,x!$C$3:$C$100,1)),"",INDEX(x!$A $3:$A$100,RANK(x!C3,x!$C$3:$C$100,1)))

Together in the Blank under stores to make it work. (not familiar with some
of the code listed)