I have odds in column A and prediction in column H
I have minimum odds in J L N which relate to whether column H is a H, D or A.
So if A2 is predicted to be a 'D' (H2) then A2 odds would have to be over 2.1 (L2)
If H2 is a 'H' then odds should be over 1.9(J2) and if H2 is 'H' odds should be be over 2(N2).
Looking for a formula I can copy down.
I have minimum odds in J L N which relate to whether column H is a H, D or A.
So if A2 is predicted to be a 'D' (H2) then A2 odds would have to be over 2.1 (L2)
If H2 is a 'H' then odds should be over 1.9(J2) and if H2 is 'H' odds should be be over 2(N2).
Looking for a formula I can copy down.
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O |
Home | Draw | Away | Home Minimum Odds | Draw Minimum Odds | Away Minimum Odds | |||||||||
6.1 | Bet | Brechin | 4.8 | Queens Park | 1.65 | D | 1.9 | H | 2.1 | H | 2 | H | ||
2.64 | No Bet | Hull | 3.65 | Barnsley | 1.82 | H | 4.6 | A | 4.1 | A | 4.3 | A | ||
1.92 | No Bet | Fulham | 3.85 | Swansea | 4.5 | H | 3 | D | 3.5 | D | 7 | D | ||
2.28 | Bet | Reading | 3.4 | Wigan | 3.6 | D | ||||||||
1.76 | No Bet | Sheffield Weds | 3.75 | Charlton | 5.8 | A |