Forum Discussion
multiple count using different rows comparing multiple columns
some assistance please! i posted something prior but i think i confused the matter. maybe this clears it up count how many times a the name in column A has a "yes" in column C and a "yes" in col...
B11 does not contain a yes in column C or D so it wouldnt change anything
its for a pool match. column B is "inning", column C is "ball in hand", column D is "win"
if a player gets ball in hand in the same inning as his win then i want to count.
its for a pool match. column B is "inning", column C is "ball in hand", column D is "win"
if a player gets ball in hand in the same inning as his win then i want to count.
You still are leaving many things unexplained. You think they're obvious things, which is why you don't think they need explanation. But they do.
You think you gave a full explanation to Harun24HR in response to his question. But you actually gave only a partial answer.
Fill out your online sample sheet with more data, realistic data, and give more examples of what the rules you're wanting to program would yield.