Jan 20 2022 12:26 PM - edited Jan 20 2022 12:46 PM
Hello,
This is volleyball statistics. I would like C3 and E3 be counted sets. How can I do this?
Jan 20 2022 12:45 PM
Could you please clarify where is C3, where is E3 and what to count.
Jan 20 2022 12:47 PM - edited Jan 20 2022 12:49 PM
I edited the first post
Count sets, for example in first match should be 2:5
Jan 20 2022 12:51 PM
SolutionIn C3: =(G3>I3)+(J3>L3)+(M3>O3)+(P3>R3)+(S3>U3)+(V3>X3)+(Y3>AA3)
In E3: =(G3<I3)+(J3<L3)+(M3<O3)+(P3<R3)+(S3<U3)+(V3<X3)+(Y3<AA3)
Fill down.
Jan 20 2022 12:51 PM
SolutionIn C3: =(G3>I3)+(J3>L3)+(M3>O3)+(P3>R3)+(S3>U3)+(V3>X3)+(Y3>AA3)
In E3: =(G3<I3)+(J3<L3)+(M3<O3)+(P3<R3)+(S3<U3)+(V3<X3)+(Y3<AA3)
Fill down.