Create a List by Ranking a List in a different tab?

[caravanbutts]

Hi

I would like excel to be able to generate a list of student names in rank order from 1-10 in a different tab to the main list that may have 60+ students listed.

For example

TAB1
Time Rank
John 10.23 4
Steve 10.34 5
Mark 9.43 1
Holly 9.87 3
Eva 9.65 2

TAB2
Time Rank
Mark 9.43 1
Eva 9.65 2
Holly 9.87 3

In this example of just gone for top 3.

 

[Yongle]

Try this (makes use of the existing structure of your sheets)

Where (in both sheets)
Column A contains names
Column B contains Times
Column C contains Rank (Tab1 contains calculated rankings)

In Tab2

In A2 copy down
=INDEX('Tab1'!A:A,MATCH(C2,'Tab1'!C:C,0))

In B2 copy down
=INDEX('Tab1'!B:B,MATCH(C2,'Tab1'!C:C,0))

Enter these values in column C
C2 = 1, C3 = 2.......C11=10

 

[caravanbutts]

Try this (makes use of the existing structure of your sheets)

Where (in both sheets)
Column A contains names
Column B contains Times
Column C contains Rank (Tab1 contains calculated rankings)

In Tab2

In A2 copy down
=INDEX('Tab1'!A:A,MATCH(C2,'Tab1'!C:C,0))

In B2 copy down
=INDEX('Tab1'!B:B,MATCH(C2,'Tab1'!C:C,0))

Enter these values in column C
C2 = 1, C3 = 2.......C11=10

Thank you so much this is brilliant!!