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

¦p¦ó¼g¨ç¼Æ©ÎVBA¾ã¦X¼Æ¾Ú

¦p¦ó¼g¨ç¼Æ©ÎVBA¾ã¦X¼Æ¾Ú

³Â·Ð¦U¦ì¤j¤j¡A¦]¬°¤½¥q¼´¥X¨Ó§e²{³o¼Ë¡C¤H¼Æ¸ò¤Ñ¼Æ³£«Ü¦h¡C·Q¾ã¦X¤@¤U Test.zip (5.82 KB)

¢ÏÄæ©m¦W¦Û¦æ¿é¤J¡I

¢Ð¢±¢³¡G¥k©Ô¤U©Ô
=IF(SUMIF($A$2:$A$19,$A24,B$2:B$19),SUMIF($A$2:$A$19,$A24,B$2:B$19),"")

TOP

http://blog.xuite.net/hcm19522/twblog/397349102
B25:I26=IFERROR(LOOKUP(1,0/(($A24=$A$2:$A$19)*(B$2:B$19<>"")),B$2:B$19),"")

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD