Travisallen2007
New Member
- Joined
- Jan 21, 2018
- Messages
- 30
- Office Version
- 365
Hello,
Thank for taking a second to read! I am really appreciative of any help you can provide.
I am looking to assign a point value to a "Overall" Table based on results from a specific field table.
EX:
One table has 16 people with results for a weeks worth of data. At the end i have made an average "Overall score" field to see who had the highest results for that time frame(In field j20-j32).
I would like for the spreadsheet to automatically assign points to the top three scores in fields (C3-c15). Scores would be 10 for top, 5 for second, 2 for third, and zero for everyone else.
is there a way to do this?
Thanks again for any help!
Thank for taking a second to read! I am really appreciative of any help you can provide.
I am looking to assign a point value to a "Overall" Table based on results from a specific field table.
EX:
One table has 16 people with results for a weeks worth of data. At the end i have made an average "Overall score" field to see who had the highest results for that time frame(In field j20-j32).
I would like for the spreadsheet to automatically assign points to the top three scores in fields (C3-c15). Scores would be 10 for top, 5 for second, 2 for third, and zero for everyone else.
is there a way to do this?
Thanks again for any help!