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

[µo°Ý] ¨ç¼Æ_¹ïÀ³¼Æ¦rªº­Ó¼Æ²Î­p

[µo°Ý] ¨ç¼Æ_¹ïÀ³¼Æ¦rªº­Ó¼Æ²Î­p

ªþ¥ó¡G ¨ç¼Æ_¹ïÀ³¼Æ¦rªº­Ó¼Æ²Î­p.rar (16.8 KB)
³Æµù¡G
H4¡GHn=Z$2¡GZ$51ªº¼Æ¦r¦U¨ú1­Ó(­°¾­±Æ§Ç)¡C

»Ý¨D¡G
·íZ$2¡GZ$51=$AH4®É¡A«h±N=$AH4ªº¦U¸ÓZ$2¡GZ$51¦P¦C¤§AA¡GAE¦U¼Æ¦rªº¥[Á`­Ó¼Æ¡A
¶ñ¤JAI3¡GBU3¬Û¦P¼Æ¦r¤U¤èªº²Ä4¦CÀx¦s®æ¤¤¡C
EX¡GAT4=2¡ABC4=1¡ABD4=1¡ABF4=1¡F¨ä¾l­Ó¼Æ=0ªºÀx¦s®æÅã¥ÜªÅ¥Õ¡C

·íZ$2¡GZ$51=$AH5®É¡A«h±N=$AH5ªº¦U¸ÓZ$2¡GZ$51¦P¦C¤§AA¡GAE¦U¼Æ¦rªº¥[Á`­Ó¼Æ¡A
¶ñ¤JAI3¡GBU3¬Û¦P¼Æ¦r¤U¤èªº²Ä5¦CÀx¦s®æ¤¤¡C
EX¡G BF4=2¡F¨ä¾l­Ó¼Æ=0ªºÀx¦s®æÅã¥ÜªÅ¥Õ¡C

¨ä¾lAI6¡GBU23¡K¡K¦P²zÃþ±À¡C

½Ð°Ý¡GAI4ªº¤@¦¡¨ì¦ì¨ç¼Æ¤½¦¡À³¦p¦ó½s¼g¡H
ÁÂÁ¡I

ªþ¥ó : ¨ç¼Æ_¹ïÀ³¼Æ¦rªº­Ó¼Æ²Î­p.rar (25.77 KB)
¬Q¤Ñ¦³¸Õ¼g¤½¦¡ :
AI4
=IF(SUMPRODUCT(($Z$2:$Z51=$AH4)*($AA$2:$AF$51=AI$3)*1)=0,"",SUMPRODUCT(($Z$2:$Z51=$AH4)*($AA$2:$AF$51=AI$3)*1))
¦ý¥u¦³AI4:BU4(²Ä4¦C)ªºµª®×¥¿½T¡A¤U©Ô«áªºµª®×¥þ³¡=#N/A¡A

Àµ½Ð¦U¦ì¤j¤j¸Ñ´b¡CÁÂÁÂ!

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2022-1-8 23:46 ½s¿è

¸Ñ¨M¤F!
­ì¨Ó¬Oº|¤F2­Ó$
AI4
=IF(SUMPRODUCT(($Z$2:$Z$51=$AH4)*($AA$2:$AF$51=AI$3)*1)=0,"",SUMPRODUCT(($Z$2:$Z$51=$AH4)*($AA$2:$AF$51=AI$3)*1))
ÁÂÁÂ!

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD