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...
because column C's "yes" happens when column B is the same number when column D is "yes"
What happens if B11 turns to 2?
I think this is still pretty confusing. You'll need to come up with more examples under varying conditions to make your underlying heuristic (rule) unambiguously clear, before it can be turned into a reliable formula.
I think this is still pretty confusing. You'll need to come up with more examples under varying conditions to make your underlying heuristic (rule) unambiguously clear, before it can be turned into a reliable formula.
- 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.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.
- most of me thinks if i explain the question more it might confuse some but im going to attempt here.
This is data from a pool match.
In pool there are games which Is column A
every change of turn by a player can change the inning by .5
as you can see in A11 it is Johns turn in the first game and the inning is 0
then its rick turn and the inning is .5
and on ricks turn (row 10) he fouls and that is reflected in column E
because he fouls it is now johns turn and now the inning is 1 because the change in turn reflects a change of .5 by inning
whenever someone fouls it is ball in hand and reflected in column D
when a player gets ball in hand I want to know if that player ultimately wins the game without giving the turn back to the other player
a win is reflected in column F
so here John won twice without giving the ball back after ball in hand
in game 1 he won on the same turn he received ball in hand
in game 2 he won 2 shots after ball in hand
each win occurred during the same inning as the ball in hand.
i really appreciate everyones assistance. im trying to achieve this with just a formula and not adding additional columns to count like a helper column.
https://1drv.ms/x/s!AnFi6uGE1reki2mZBJz9KxQLchAK?e=D16fGf