Book1 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EM | EN | EO | EP | EQ | ER | ES | ET | EU | EV | EW | EX | EY | |||
1 | 21511 | 11521 | 12511 | 11611 | |||||||||||
2 | |||||||||||||||
3 | |||||||||||||||
4 | |||||||||||||||
5 | |||||||||||||||
6 | 11611 | 21511 | 11611 | 12511 | 11611 | 11521 | 21511 | 11521 | 12511 | 11611 | 11611 | 11611 | |||
7 | 11611 | 11521 | 11521 | 11611 | 11611 | 12511 | 11521 | 11521 | 12511 | 11611 | 11611 | 11611 | |||
8 | 11611 | 12511 | 12511 | 12511 | 11611 | 11611 | 12511 | 12511 | 12511 | 11611 | 11611 | 11611 | |||
9 | 11611 | 11521 | 12511 | 11521 | 12511 | 12511 | 11521 | 11521 | 12511 | 12511 | 12511 | 11611 | |||
sheet |
Cell Formulas | ||
---|---|---|
Range | Formula | |
ET6:EY9 | ET6 | =IF(COUNTIF($EM6:$ER6,$ET$1)-COUNTIF($ES6:ES6,$ET$1)>0,$ET$1, IF(COUNTIF($EM6:$ER6,$EU$1)-COUNTIF($ES6:ES6,$EU$1)>0,$EU$1, IF(COUNTIF($EM6:$ER6,$EV$1)-COUNTIF($ES6:ES6,$EV$1)>0,$EV$1, IF(COUNTIF($EM6:$ER6,$EW$1)-COUNTIF($ES6:ES6,$EW$1)>0,$EW$1)))) |