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

[µo°Ý] ¸ê®Æ¾ã²zªº¤½¦¡

[µo°Ý] ¸ê®Æ¾ã²zªº¤½¦¡

¦U¦ì«e½ú¤j®a¦n¡G
¦³¤@°ÝÃD·Q½Ð±Ð¡A¦pªþ¥ó¡C
»¡©ú¦p¤U¡G
¸ê®Æ©ñ¦bresult¤¤¡A¦ý§Æ±æ¯à¦b¥t¤@­Ó¤u§@ªí¥ý¨ÌBX,CT(resultªºA column)¡A¦A¨ÌD01,D02,D03¾ã²z(resultªºB column)¡A¦ý¬OD01¤S¥i¤À¬°A,B,C,D(resultªºC column¦ý¤]¤£¤@©w³£¦³­È)¡A´«¥y¸Ü»¡´N¬O¡G
TableªºB4¬O­n¦bresult¤¤¦P®É²Å¦XBX, D01, A¥H¤ÎY1ªº¼Æ¾Ú¡A
               C4¬O­n¦bresult¤¤¦P®É²Å¦XBX, D01, A¥H¤ÎY2ªº¼Æ¾Ú¡A
               B5¬O­n¦bresult¤¤¦P®É²Å¦XBX, D01, B¥H¤ÎY1ªº¼Æ¾Ú¡A
             B12¬O­n¦bresult¤¤¦P®É²Å¦XCT, D01, A¥H¤ÎY1ªº¼Æ¾Ú¡A
             B22¬O­n¦bresult¤¤¦P®É²Å¦XBX, D02, A¥H¤ÎY1ªº¼Æ¾Ú¡A
¥H¦¹Ãþ±À¡C
¦]¬°Result¤¤ªºD0*¤j¬ù¦³40ºØ¡A¦Ó¥B¸ê®Æ¼Æ¶q·|ÅÜ¡A¦³¨Çitem¤£¤@©w¨C¦¸¦³­È(¹³¬OA,B¤§Ãþªº)¡A©Ò¥H§Ú¨C¦¸§ó·s§¹³£±oÀˬd¬O§_¦³¶]±¼¡A¹ê¦b¤Ó¯Ó®É¡A©Ò¥H¨Ó½Ð±Ð«e½ú¡A¬O§_¦³¤ñ¸û¤è«Kªº¤½¦¡¡C
¥ýÁÂÁ¤j®aÅo¡I

½d¨Ò.zip (23.79 KB)

B4=SUMPRODUCT((result!$A$4:$A$54=CHOOSE(INT(ROW()/9)+1,$A$2,$A$10,$A$20,$A$28,$A$37,$A$45))*(result!$B$4:$B$54=INDIRECT("A"&MAX(IF(ISNUMBER(FIND("D0",$A$1:A4)),ROW($A$1:A4)))))*(result!$C$4:$C$54=$A4)*(result!$E$3:$Y$3=B$3)*result!$E$4:$Y$54)

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD