Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with a function for a golf match spreadsheet
I am a High School golf coach and I would like to be able to rank 12 scores
from 2 different columns and assign a point value based on their finish. Since we have 6 golfers from each team they will be located in 2 seperate columns For example the golfer with the best score recieves 12 points toward all conference honors the next best score recieves 11 etc... all the way down to 1 point. I would also need to be able to divide the points between golfers with the same score. My sheet looks something like this below: A B C E F G Name Score Points Name Score Points 7 0 0 8 0 0 9 0 0 10 0 0 11 0 0 12 0 0 Team Score 0 Team Score 0 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with a function for a golf match spreadsheet
Here's a small sample file that demonstrats this:
Point distribution.xls 15kb http://cjoint.com/?exjuPzHPO6 -- Biff Microsoft Excel MVP "Bodman34" wrote in message ... I am a High School golf coach and I would like to be able to rank 12 scores from 2 different columns and assign a point value based on their finish. Since we have 6 golfers from each team they will be located in 2 seperate columns For example the golfer with the best score recieves 12 points toward all conference honors the next best score recieves 11 etc... all the way down to 1 point. I would also need to be able to divide the points between golfers with the same score. My sheet looks something like this below: A B C E F G Name Score Points Name Score Points 7 0 0 8 0 0 9 0 0 10 0 0 11 0 0 12 0 0 Team Score 0 Team Score 0 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does any one have a Golf Tournament spreadsheet for teams? | Excel Discussion (Misc queries) | |||
Spreadsheet to compute the swing weight of a golf club... | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
Summary statistics for a golf scores spreadsheet | Excel Worksheet Functions | |||
GOLF Spreadsheet problem | Excel Worksheet Functions |