Hi

I'm a bit of a lurker around here and couldn't find the answer to my question by seaching, so here goes ..

I run a football tipping comp and one of the prizes is based on a "pick-the-score" competition. The players choose a score eg. 30-6 and the player(s) who correctly pick the margin and score are the winner. I can get the formula working to show "Winner" where the score is exact, but I am trying to work out a way to do this if nobody picks the exact score (in which case the prize goes to the closest score).

OK, here is an example.
Winning score is 30-6, so the correct margin is 24.
======================================
Player 1 - 10-4 (Margin is 6)
Player 2 - 22-10 (Margin is 12)
Player 3 - 30-4 (Margin is 26)
Player 4 - 23-3 (Margin is 20)
Player 5 - 12-2 (Margin is 10)
Player 6 - 10-18 (Margin is 8)
Player 7 - 32-16 (Margin is 16)

As nobody has a margin of 24, the closest would be Player 3 with 26.

Example 2
=========
Still using the players above. If the margin was 11, then both Players 2 and 5 share the prize as they are the closest.

Can anyone give me a formula that would do this for me please?