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.
You may consider the function SMALL.
SMALL(A:A,k) means the k-th smallest value in the column A.