Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot tables - how can i set one up with data points over time? | Charts and Charting in Excel | |||
Can this be done using an array formula ? | Excel Worksheet Functions | |||
hlookup function | Excel Worksheet Functions | |||
Match and Sort for two range of data on different worksheets? | New Users to Excel | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) |