Hi All,
I'm a newbie here and I would really appreciate it if you guys can help me in fixing, improving my current excel spreadsheet. My objectives are as follows:
1) To automatically make the range of selected cells choose ONLY the lowest 10 posted out of 20 posted scores
2) To get the average of those 10 lowest scores
3) To multiply the average of the 10 lowest scores by .96
The result would be the handicap index which I am looking for.
Can you guys give me the formulas needed in achieving this?
Thanks so much for the help!
Cheers!
Bookmarks