gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 657
- Office Version
- 2019
- Platform
- Windows
Every time is hit "save" I get this result.
H:H and A:A are changing. There both correct when filled.
H:H and A:A are changing. There both correct when filled.
Wagers.xlsm | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
90 | #N/A | 9/9 | NFL | SPRD | $ 5.00 | $ 4.35 | TB | DAL | -7.5 | -$5.00 | AA:AN (SRS/Pass/Pts) | |||
91 | -$5.00 | |||||||||||||
92 | $119.81 | Balance | ||||||||||||
NFL |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A90 | A90 | =INDEX('[NFL.xlsm]Weekly Picks'!$D$4:$D$35,MATCH($H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,0)) |
H90 | H90 | =IFERROR(LOOKUP(2, 1/((COUNTIF($H$90:$H90,'[NFL.xlsm]Weekly Picks'!$H$4:$H$35)=0)*('[NFL.xlsm]Weekly Picks'!$H$4:$H$35<>"")),'[NFL.xlsm]Weekly Picks'!$H$4:$H$35),"") |
I90 | I90 | =IF(1=MOD(MATCH(H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,0),2),INDEX('[NFL.xlsm]Weekly Picks'!$A$4:$A$35,MATCH(H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,0)+1),INDEX('[NFL.xlsm]Weekly Picks'!$A$4:$A$35,MATCH(H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,0)-1)) |
J90 | J90 | =INDEX('[NFL.xlsm]Weekly Picks'!$B$4:$B$35,MATCH($H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,FALSE)) |
L90 | L90 | =INDEX('[NFL.xlsm]Weekly Picks'!$G$4:$G$35,MATCH($H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,FALSE)) |
C92 | C92 | =124.81+K91 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A90 | A90 | =INDEX('[NFL.xlsm]Weekly Picks'!$D$4:$D$35,MATCH($H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,0)) |
H90 | H90 | =IFERROR(LOOKUP(2, 1/((COUNTIF($H$90:$H90,'[NFL.xlsm]Weekly Picks'!$H$4:$H$35)=0)*('[NFL.xlsm]Weekly Picks'!$H$4:$H$35<>"")),'[NFL.xlsm]Weekly Picks'!$H$4:$H$35),"") |
I90 | I90 | =IF(1=MOD(MATCH(H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,0),2),INDEX('[NFL.xlsm]Weekly Picks'!$A$4:$A$35,MATCH(H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,0)+1),INDEX('[NFL.xlsm]Weekly Picks'!$A$4:$A$35,MATCH(H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,0)-1)) |
J90 | J90 | =INDEX('[NFL.xlsm]Weekly Picks'!$B$4:$B$35,MATCH($H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,FALSE)) |
L90 | L90 | =INDEX('[NFL.xlsm]Weekly Picks'!$G$4:$G$35,MATCH($H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,FALSE)) |
C92 | C92 | =124.81+K91 |