- ©«¤l
- 2833
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2889
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-12
|
¥»©«³Ì«á¥Ñ ã´£³¡ªL ©ó 2015-11-22 10:34 ½s¿è
¦^´_ 7# LITTLEFAT7048
¨C¤ë¨âÓ¤H¡e¦P¤@¤Ñ¦P®É©ñ°²¡f¤Ñ¼Æ
°}¦C¤½¦¡¡G
=SUM(COUNTIF(B52:F54,B3:AF3)*COUNTIF(J52:N54,B4:AF4))
=COUNT(RANK(B3:AF3,B52:F54)*RANK(B4:AF4,J52:N54))
¤@¯ë¤½¦¡¡G
=SUMPRODUCT(COUNTIF(B52:F54,B3:AF3)*COUNTIF(J52:N54,B4:AF4))
=SUMPRODUCT(1-ISNA(RANK(B3:AF3,B52:F54)*RANK(B4:AF4,J52:N54)))
¡Õ°}¦C¤½¦¡¡Ö¿é¤Jªk
¿é¤J©Îק綠¦¡§¹¦¨«á¡A´å¼Ð¯d¦b¡e½s¿è¦C¡f¡A¥ý¤£n«öEnter¡A
¦P®É«ö¦í¡eShift + Ctrl¡f¤£©ñ¡A¦A«ö¡eEnter¡f¡C
Y¹ïRANK¥ÎªkÁÙ¤£¼ô±x¡A«Øij¥ý°µ°Ñ¦Ò¡ACOUNTIF¸û¦n²z¸Ñ¡ã¡ã
¥t ¡G
¢°¡DB52 ¤½¦¡¶·§ï¬°¡G=IF(¿é¤J°Ï!B4="","",¿é¤J°Ï!B4)¡A¨ä¥¦®æ¥çµM¡A§_«h¡eªÅ®æ¤Î¢¯È¡f·|»~§P¬°¬Û¦P¡I
¢±¡D¿é¤J°Ï¸¹½X¤£¥i«ÂÐ
|
|