Excel Help
I'm trying to get a excel doc made up, and I know there should be a way to do what I want but I can't think of it.
I'm doing a golf tourny with buddies and we're going to track our scores on a shared Excel doc. I want to make a master tab that will show everyones scores. Simple.
However, I want to have it also show what hole everyone is on. I was thinking of something like "If the score of a player is filled out, then display this cell's value". So if a pair has finished hole 5, they put in their score, and the formula would pick up "oh hole 5 is filled out, they must be on hole 6". But I can't think of how to run that formula.
Any help would be great.
12 Team, H2H, Keep 6 (in Bold)
G, A, Pts, PPP, FW, SOG, Hits, Blocks
W, Saves, S%, GAA, Game Started
2C, 2LW, 2RW, 4D, 1Util, 2G, 5BN, 2IR, 1IR+, 1NA
C: Horvat, Trocheck
LW: J. Robertson, Byfield (C), Guenther
RW: Pavelski (C), Giroux (C), Svechnikov (LW)
D: Fox, Makar, Bouchard, Morrissey, Gudas
Util: Meier (LW, RW)
G: Oettinger, Georgiev, Samsonov, Woll