Forum Discussion
Solved
Excel newbie
Hi. I’m trying to run a sports type league where competitors are awarded points at the end of every event. 1 point per position, lowest score wins the league. There are 10 events, which are added in t...
Mike-
Try using this formula:
=SUM(C4:L4)-LARGE(C4:L4,1)-LARGE(C4:L4,2) Your data should look something like this....
Please see the attached file for further reference. Hope this helps.
Mike-
Try using this formula:
| =SUM(C4:L4)-LARGE(C4:L4,1)-LARGE(C4:L4,2) |
Your data should look something like this....
Please see the attached file for further reference. Hope this helps.
You Sir, are a saviour and a gentleman. The formula works perfectly. Many thanks for your contribution.
Glad you were able to get it working. You're welcome. Please feel free to post back to the community with any other inquiries!