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

[µo°Ý] #NUM!Åã¥ÜªÅ¥Õ

[µo°Ý] #NUM!Åã¥ÜªÅ¥Õ

Book1.rar (2.14 KB)
·QÅý#NUM!Åã¥ÜªÅ¥Õ
½Ð°Ý : C9ªº¤½¦¡­n¦p¦ó­×§ï¡H
ÁÂÁ¡I

¸É¥R»Ý¨D¤½¦¡ªº¤å¦r»¡©ú :
·í²Ä8¦Cªº¬Y¼Æ¦r¦³Åã¥Ü¦b²Ä3¦C®É¡A«h²Ä9¦CÅã¥Ü¸Ó²Ä3¦C¬Y¼Æ¦rªº¦PÄæ²Ä2¦Cªº¼Æ¦r¡F§_«hÅã¥Ü""¡C
¨Ò¦p : C8=3¡A¨S¦³Åã¥Ü¦b²Ä3¦C®É¡AC9=""¡FD8=5=C3¡A«hD9Åã¥Ü=C2=1¡F.....¨ä¾lÃþ±À¡C
ÁÂÁÂ !

TOP

°ÝÃD¤w¸Ñ¨M¡CÁÂÁÂ!
C9=IF(C8="","",IF(COUNTIF($C3:$V3,C8)=0,"",INDEX($2:$2,SMALL(IF($C3:$V3=C8,COLUMN($C:$V)),COUNTIF($C8:C8,C8)))))
°}¦C¤½¦¡

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 4# hcm19522
ÁÂÁ±z¦h¦¸ªºÀ°¦£©M«ü¾É!

TOP

³£¬O¥¿¾ã¼Æ, ¨S¦³0
=TEXT(SUMIF($C3:$V3,C8,$C2:$V2),"0;;;")

TOP

¦^´_ 6# ­ã´£³¡ªL
·PÁª©¥Dªº«ü¾É!

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD