ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¶À¦â°Ï°ì¼Æ¦r¥X²{«ü©w¼Æ¦r°ÝÃD

[µo°Ý] ¶À¦â°Ï°ì¼Æ¦r¥X²{«ü©w¼Æ¦r°ÝÃD

¥»©«³Ì«á¥Ñ jeff5424 ©ó 2010-8-13 23:18 ½s¿è

¦pªþªñ©Ò¥Ü
B44¬°¥X²{¸¹¶Ü
B12:N3¬°«ü©w¸¹¶Ü(¶À¦â°Ï°ì)
ÂŦ⬰¤ñ¹ï«áªºµ²ªG
1=B12:N3 26­Ó¸¹½X¨ä¤¤¥X²{1²Õ¬Û¦P¸¹½X   
0=B12:N3 26­Ó¸¹½X¤£¬Û¦P¸¹½X

­º¥ý·PÁ¦U¦ì¤j¤jªº¨ó§U  ÁÂÁÂ

«ü©w°ì°Ï¸¹½X¬Û¦P¦^³ø°ÝÃD.rar (2.91 KB)

ªþ¥ó

¦^´_ 1# jeff5424


ªþ¥ó©O?
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

§ó·s¸Éªþ¥ó
·PÁÂasimov¾Çªø´£¿ô  ÁÂÁÂ

TOP

¦^´_ 1# jeff5424


§Æ±æ¨S¦³»~¸Ñ±zªº·N«ä
Q16=IF(COUNTIF($B$15:$N$16,B4),1,0)
¦V¥k½Æ»s
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

·PÁÂasimov¾Çªø§iª¾
=IF(COUNTIF($B$15N$16,B4),1,0)
§¹¥þ¥¿½T

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD