Looks much simpler if it's not across sheets (sheetname is dropped)
Put this in B2:
=IF(ISNA(RANK(D2,$D$2:$D$100,1)),"",INDEX($C$2:$C$ 100,RANK(D2,$D$2:$D$100,1)))
Copy down to B100.
--
Max
Singapore
---
"Matlock" wrote:
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)