Sort and Rank Data

[Sharonits]

What would be the easiest way to sort and assign a rank?

On my worksheet I import three columns of info: Name, rank and team. I have a fourth column points. I then sort by rank and assign points to the top 30 only. 1st = 30, 2nd=29, etc until i reach position 30. all others below that get a 0. I have been doing this manually, what would be an easier way so I could set up all the worksheets prior and then just import the data? What function would work?

[K m]

What about using the RANK formula?

[Sharonits]

Tried but I can't get it to work. Must be inputting formula incorrect. if rank is in column c and I want the descending number assigned to the rank in column d ( 1=30, 2=29, etc.) how would I write that?

[K m]

Sample Data?

[Sharonits]

Here is the worksheet. I trying to use the rank column data and assign the points value in the points column. 1 = 30, 2 = 29, etc.

Rank.xlsx

[charm1]

How about creating a ghost table
1 = 30
2 = 29
3 = 28 and so on
and then just use vlookup function

[FDibbins]

Try this in D, copied down...

=IF(RANK(B2,$B$2:$B$74,1)>30,"",30-RANK(B2,$B$2:$B$74,1)+1)

[K m]

Try this spreadsheet