Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pivot tables - how can i set one up with data points over time? Christopher Charts and Charting in Excel 0 June 27th 06 07:53 PM
Can this be done using an array formula ? borntorun75 Excel Worksheet Functions 4 May 4th 06 12:24 PM
hlookup function ahiru Excel Worksheet Functions 5 March 30th 06 08:23 PM
Match and Sort for two range of data on different worksheets? Tan New Users to Excel 3 March 9th 06 08:55 AM
Newbie to charts question - projecting values between data points 38N90W Excel Discussion (Misc queries) 3 January 6th 05 05:15 AM


All times are GMT +1. The time now is 04:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"