- ©«¤l
- 1387
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1397
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-11-22
|
¥»©«³Ì«á¥Ñ hcm19522 ©ó 2016-10-10 14:31 ½s¿è
I16=IF(MAX(MMULT(COUNTIF(B16:G16,OFFSET(B15,,,-I5,6)),{1;1;1;1;1;1}))>3,1,"")
¤è¦¡¤G{=IF(MAX(MMULT(IF(ISNA(MATCH(OFFSET(B15,,,-I5,6),B16:G16,)),,1),{1;1;1;1;1;1}))>3,1,"")
I5¿é¤J¤W±À´X¦C
http://blog.xuite.net/hcm19522/twblog/456048737 |
|