Preacherman771
New Member
- Joined
- Jun 15, 2021
- Messages
- 46
- Office Version
- 365
- Platform
- Windows
I list football scores down various cells in various columns. Below each cell with a score, I am wishing to determine whether the left number of the score is greater than, less than or equal to the right score. When I use the exact same formula, I do not receive the correct value consistently. Would appreciate any help in determining the reason(s) for the inconsistency.
NFL 2021-2022 Standings (Template).xlsx | ||||
---|---|---|---|---|
G | H | |||
190 | 38-3 | 27-3 | ||
191 | W | L | ||
192 | 0.500 | |||
193 | 47-42 | 38-6 | ||
194 | W | L | ||
195 | 0.500 | |||
196 | ||||
197 | ||||
198 | ||||
199 | 33-16 | |||
200 | W | |||
201 | 1.000 | |||
202 | 24-10 | |||
203 | W | |||
204 | 1.000 | |||
205 | 40-14 | |||
206 | W | |||
207 | 1.000 | |||
208 | 20-34 | |||
209 | L | |||
210 | 0.000 | |||
Calc_Results |
Cell Formulas | ||
---|---|---|
Range | Formula | |
G190,G193,G196,G199,G202,G205,G208 | G190 | =IF(IFERROR(INDEX(Tab_Schedule[ScoreA],MATCH(1,(G$182=Tab_Schedule[Away])*($C190=Tab_Schedule[HOME]),0)),"")="","",INDEX(Tab_Schedule[ScoreA],MATCH(1,(G$182=Tab_Schedule[Away])*($C190=Tab_Schedule[HOME]),0))&"-"&INDEX(Tab_Schedule[ScoreH],MATCH(1,(G$182=Tab_Schedule[Away])*($C190=Tab_Schedule[HOME]),0))) |
H190,H193,H196,H199,H202,H205,H208 | H190 | =IF(IFERROR(INDEX(Tab_Schedule[ScoreH],MATCH(1,(G$182=Tab_Schedule[HOME])*($C190=Tab_Schedule[Away]),0)),"")="","",INDEX(Tab_Schedule[ScoreH],MATCH(1,(G$182=Tab_Schedule[HOME])*($C190=Tab_Schedule[Away]),0))&"-"&INDEX(Tab_Schedule[ScoreA],MATCH(1,(G$182=Tab_Schedule[HOME])*($C190=Tab_Schedule[Away]),0))) |
G191:H191,G194:H194,G197:H197,G200:H200,G203:H203,G206:H206,G209:H209 | G191 | =IF(G190="","",IF(LEFT(G190,FIND("-",G190)-1)>RIGHT(G190,LEN(G190)-FIND("-",G190)),"W",IF(LEFT(G190,FIND("-",G190)-1)<RIGHT(G190,LEN(G190)-FIND("-",G190)),"L","T"))) |
G192,G195,G198,G201,G204,G207,G210 | G192 | =IF(AND(G191="",H191=""),"",IF(AND(G191="-------",H191="-------"),"-------",SUM(((0.5*COUNTIF(G191:H191,"T"))+COUNTIF(G191:H191,"W"))/SUM(COUNTIF(G191:H191,"W")+COUNTIF(G191:H191,"L")+COUNTIF(G191:H191,"T"))))) |
Press CTRL+SHIFT+ENTER to enter array formulas. |