ivankesaulya
New Member
- Joined
- Feb 2, 2018
- Messages
- 6
ivankesaulya.xlsx | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
H | I | J | K | L | M | N | O | P | Q | R | S | T | |||
3 | Target | Winning | |||||||||||||
4 | AR | AR | 0110 | 0210 | 0310 | 0410 | 0510 | 0610 | 0710 | 0810 | 0910 | 1010 | 1110 | ||
5 | |||||||||||||||
6 | 25% | 0 | 12.4% | 11.7% | 14.0% | 14.1% | 15.0% | 10.9% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | ||
7 | 15% | 3 | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 16.2% | 9.3% | 3.3% | 4.4% | 14.5% | ||
8 | 23% | 0 | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 16.2% | 9.3% | 3.3% | 4.4% | 14.5% | 3.3% | ||
9 | 13% | 7 | 1.0% | 14.5% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 16.2% | 9.3% | 3.3% | 4.4% | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
I6:I9 | I6 | =COUNTIF(K:Q,">"&H6) |
Yesssss ..Hi ivankesaulya,
It's not clear where the result should go or which cells to look at so I'll assume if any row of K through Q is greater than the single row of Target AR for that row.
ivankesaulya.xlsx
H I J K L M N O P Q R S T 3 Target Winning 4 AR AR 0110 0210 0310 0410 0510 0610 0710 0810 0910 1010 1110 5 6 25% 0 12.4% 11.7% 14.0% 14.1% 15.0% 10.9% 0.0% 0.0% 0.0% 0.0% 0.0% 7 15% 3 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 16.2% 9.3% 3.3% 4.4% 14.5% 8 23% 0 0.0% 0.0% 0.0% 0.0% 0.0% 16.2% 9.3% 3.3% 4.4% 14.5% 3.3% 9 13% 7 1.0% 14.5% 0.0% 0.0% 0.0% 0.0% 0.0% 16.2% 9.3% 3.3% 4.4% Sheet1
Cell Formulas Range Formula I6:I9 I6 =COUNTIF(K:Q,">"&H6)