I am a bit OCD and decided to analyze my stats for a game I like to play.
The game consists of several rounds of play and all rounds are summed up to get the total score.
I have the formula for comparing two columns and counting when one is greater than the other.
Now I want to extend this and count the number of "perfect" games I've had; how many times did I win in round 1 and round 2 and round 3?
Sample Data:
R1 R2 R3 T1 R1 R2 R3 T2
351 521 448 1320 360 577 675 1612
663 825 795 2283 657 747 538 1942
346 770 638 1754 261 955 973 2189
498 497 679 1674 523 414 1021 1958
The first set data are the opponent's, the second mine.
Is this doable with built in functions or do I need a UDF?
Thanks in advance.
Bookmarks