This one has got me stuck. I'm trying to score multiple dual track meets while 3 teams compete simultaneously. In the scoring the 1st and 2nd place positions for each dual meet must come from the 1st heat only. 3rd thru 6th place can come from any of the heats. I realize that there will probably be a different formula for 1st/2nd and 3rd-6th.
I've attached a small sample worksheet with the desired results highlighted in yellow with an explanation of the results below the highlighted cells.
Bookmarks