gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 660
- Office Version
- 2019
- Platform
- Windows
Hello,
If all 4 are True = 1 count.
Line 5 vs Line 6
B5 ="W"
X5 <X6
Y5 >Y6
Z5 >Z6
Line 6 should count 1.
Then 7 vs 8, 9 vs 10, 11 vs 12, etc.
In groups of 2.
Row count is 5:30
thanks
If all 4 are True = 1 count.
Line 5 vs Line 6
B5 ="W"
X5 <X6
Y5 >Y6
Z5 >Z6
Line 6 should count 1.
Then 7 vs 8, 9 vs 10, 11 vs 12, etc.
In groups of 2.
Row count is 5:30
thanks
Cell Formulas | ||
---|---|---|
Range | Formula | |
X5:X18 | X5 | =IFERROR(VLOOKUP($A5,TeamRankings!$CC:$CN,12,0),"") |
Y5:Y18 | Y5 | =VLOOKUP(A5,TeamRankings!$CC$3:$CP$32,14,0) |
Z5:Z18 | Z5 | =VLOOKUP(A5,TeamRankings!$CC$3:$CQ$32,15,0) |