ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Generating points from 2 tables (IF funtion limited) (https://www.excelbanter.com/excel-worksheet-functions/97778-generating-points-2-tables-if-funtion-limited.html)

race39

Generating points from 2 tables (IF funtion limited)
 
I am trying to generate the points earned in an event, as follows:

The first table (START) shows the starting order(with entrant #38 being used
as example)

START

1st 2nd
3rd 4th
5th 6th
7th #38
9th 10th
11th 12th

The second table (FINISH) show the results.
The third table (FINISH POSITION) sorts the finish order sorted into a column

FINSH FINISH POINTS
POSITION
38 48 1 38 32
58 98 2 48
22 26 3 58
23 03 4 98
07 24 5 22
27 28 6 26
7 23
8 03
9 07
10 24
11 27
12 28

The winner gets 18 pts
Second place gets 18-2=16pts
Third gets 18-2-2=14pts
etc.

In additon passings points are awarded
2 points for each position gained from starting positon.

eg.
#38 is awarded 18pts for the win
#38 started in the 8th position and is awarded 14pts for passing
#38 total pts is 32, as shown in 4th table (POINTS)

This total was generated using the IF function, which is limited to 7
conditions, therefore I cannot use it with a table of 12 entrants.
Can you suggest a complete solution?
I will need an example.
TX



All times are GMT +1. The time now is 02:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com