I am trying to allocate points related to finishing position.
I have used "RANK" to determine finishing position.
Example:
IF D1=1 then D2=25
IF D1=2 then D2=20
IF D1=3 then D2=17
IF D1=4 then D2=15
etc. down to position 20 approx

You need to provide the details on the entire point distribution. Also, how
should ties (if possible) be handled?

Typically, ties split the pool. For example...

1st place = 100 pts
2nd place = 75 pts

If there are 2 tied for 1st place they each recieve 100+75/2 = 87.5 pts


--
Biff
Microsoft Excel MVP


"Not too bright" <Not too wrote in message
...
I am trying to allocate points related to finishing position.
I have used "RANK" to determine finishing position.
Example:
IF D1=1 then D2=25
IF D1=2 then D2=20
IF D1=3 then D2=17
IF D1=4 then D2=15
etc. down to position 20 approx

Thanks TV

The points distribution is:-
1st - 25 points
2nd - 20
3rd - 17
4th - 15
5th - 14
6th - 13
5th - 12
6th - 11
7th - 10
8th - 9
9th - 8
10th - 7
11th - 6
12th - 5
13th - 4
14th - 3
15th - 2
16th - 1
17th - 1
18th - 1
19th - 1
20th - 1
All additional placings = 1

Full points will be allocated to ties i.e. 3 of 1st places all receive 25
points
Of coarse the next placed person will be 4th with the allocation of 15 point

The "RANK" function sorts the places out satisfactorily, I just need to
address each rank cell with the correct points - Thanks again

"T. Valko" wrote:

You need to provide the details on the entire point distribution. Also, how
should ties (if possible) be handled?

Typically, ties split the pool. For example...

1st place = 100 pts
2nd place = 75 pts

If there are 2 tied for 1st place they each recieve 100+75/2 = 87.5 pts


--
Biff
Microsoft Excel MVP


"Not too bright" <Not too wrote in message
...
I am trying to allocate points related to finishing position.
I have used "RANK" to determine finishing position.
Example:
IF D1=1 then D2=25
IF D1=2 then D2=20
IF D1=3 then D2=17
IF D1=4 then D2=15
etc. down to position 20 approx

Ok, create a 2 column table with the place in the left column and the
corresponding pts in the right column:

...........G..........H
1........1..........25
2........2..........20
3........3..........17
4........4..........15
..........................
20.....20..........1

Assume rank is in A1.

=VLOOKUP(A1,$G$1:$H$20,2)

Copy down as needed.

--
Biff
Microsoft Excel MVP


"Not too bright" wrote in message
...
Thanks TV

The points distribution is:-
1st - 25 points
2nd - 20
3rd - 17
4th - 15
5th - 14
6th - 13
5th - 12
6th - 11
7th - 10
8th - 9
9th - 8
10th - 7
11th - 6
12th - 5
13th - 4
14th - 3
15th - 2
16th - 1
17th - 1
18th - 1
19th - 1
20th - 1
All additional placings = 1

Full points will be allocated to ties i.e. 3 of 1st places all receive 25
points
Of coarse the next placed person will be 4th with the allocation of 15
point

The "RANK" function sorts the places out satisfactorily, I just need to
address each rank cell with the correct points - Thanks again

"T. Valko" wrote:

You need to provide the details on the entire point distribution. Also,
how
should ties (if possible) be handled?

Typically, ties split the pool. For example...

1st place = 100 pts
2nd place = 75 pts

If there are 2 tied for 1st place they each recieve 100+75/2 = 87.5 pts


--
Biff
Microsoft Excel MVP


"Not too bright" <Not too wrote in
message
...
I am trying to allocate points related to finishing position.
I have used "RANK" to determine finishing position.
Example:
IF D1=1 then D2=25
IF D1=2 then D2=20
IF D1=3 then D2=17
IF D1=4 then D2=15
etc. down to position 20 approx