Hey all,
I've been working on modifying a workbook to track youth sports( Soccer) data. I'm not able to figure out how to make it so I can reflect a reentry into the game (getting subbed out then back in) Here is the formula I'm using currently. It's working well to track a player starting (starter) and is getting subbed out (SO) and vise versa.. the issue is when they get subbed back in (SI) it doesn't continue add the additional time played.. nor does it stop the time of a player being taken back out who was considered a sub (bench) to start the game.
($Q7="Starter",IFERROR(INDEX(INDIRECT("'"&$B7&"'!"&"$b25:$b74"),MATCH(F7&"SO",INDIRECT("'"&$B7&"'!"&"$d25:$d74")&INDIRECT("'"&$B7&"'!"&"$e25:$e74"),0),0),$C7),IF($Q7="Bench",$C7-IFERROR(INDEX(INDIRECT("'"&$B7&"'!"&"$b25:$b74"),MATCH(F7&"SI",INDIRECT("'"&$B7&"'!"&"$d25:$d74")&INDIRECT("'"&$B7&"'!"&"$e25:$e74"),0),0),$C7),0))
EDIT- Added Workbook
Bookmarks