(11-28-2017, 05:47 PM)timeconsumer Wrote:I would change the IF() formula to point to specific cells to find which game has which winner rather than relying on someone to manually edit the "outlaws" or "otters" sections of it.
Yeah that's a great idea! That way the grader can indicate who won which game in another column and have the TPE earned be based on that result through a vlookup. I'll need to play around with that more since this is a WIP.
