Using rank formula Si that the result ends the opposite way

[Alpacino]

Let me explain. I have a table like a league. I like to give points to the team with the best result the total number of teams in the league and and the worst 1
Table contains 24 teams
E.g team A is the best so they will get 24 points for coming 1st
E.g team X is the worst so they will get 1 point for coming 24th

I want to use rank to tell me what position they are in 1st 2nd etc but then give them points.

So question is how to do this. Perhaps negative rank so assigns lookup name with opposite value??

Anyone help???

Thanks

 

[Matty]

Let's assume your data is as follows (including headers): Teams in A1:A25; Points in B1:B25; Positions in C1:C25.

In B2, copied down, try:

=COUNTA(A2:A$25)

In C2, copied down, try:

=RANK(B2,B$2:B$25,0)

Matty

 

[T. Valko]

Let me explain. I have a table like a league. I like to give points to the team with the best result the total number of teams in the league and and the worst 1
Table contains 24 teams
E.g team A is the best so they will get 24 points for coming 1st
E.g team X is the worst so they will get 1 point for coming 24th

I want to use rank to tell me what position they are in 1st 2nd etc but then give them points.

So question is how to do this. Perhaps negative rank so assigns lookup name with opposite value??

Anyone help???

Thanks

Maybe this...

Book1
	A	B	C
1	Team	Score	Points
2	Team1	66	10
3	Team2	66	10
4	Team3	35	8
5	Team4	33	7
6	Team5	25	6
7	Team6	23	5
8	Team7	21	4
9	Team8	18	3
10	Team9	17	2
11	Team10	3	1
Sheet1

This formula entered in C2 and copied down:

=COUNTIF(B$2:B$11,"<="&B2)