In source sheet say teams are in A2:A11, rank in B2:B11. In
destination enter the ranks (1, 2, 3...) in A2:A11. In B2:

=INDEX(Sheet1!$A$2:$A$11,MATCH(A2,Sheet1!$B$2:$B$1 1,0))

HTH
Kostis Vezerides

On Nov 4, 6:37*pm, VoxBox-Richard
wrote:
I have data that is ranked on one sheet and I would like to display the data
on another sheet in rank order.

I.e,
On one sheet I have team names followed by the rank. *On the other sheet I
would like to display the teams in rank order.

I really cant think of a way to do this, my problem is that sometimes I have
a situation where I have two firsts. *I can't think away around it.

I would also ideally like the list to auto update.

Thank you.

R.