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

[µo°Ý] ¨D!­«½Æ¿z¿ï¥H¤Î³æÄ椺®e­Y±ø¥ó²Å¦X°µ¬Û¥[

[µo°Ý] ¨D!­«½Æ¿z¿ï¥H¤Î³æÄ椺®e­Y±ø¥ó²Å¦X°µ¬Û¥[

´ú¸Õ¹Ï¤ù.png
2017-8-26 22:40

§Æ±æ¦U¦ì¤j¤j¯àÀ°¦£·Q¤@¤U³o­Óªí®æ¤º©Ò»Ý­nªº±ø¥ó!ÁÂÁÂ!!
1.§Æ±æ¥i¥H¢ÏÄæ¤Î¢ÐÄ檺¤º®e¦pªG¤w¸g¦³¿é¤J¹Lªº¸Ü¡A¢ÑÄæ¥i¥HÅã¥Ü­«½ÆEX:A2Äæ»PA4Ä椺®e¬Û¦P¥BB2Äæ»PB4Äæ¬Û¦P,C2¤ÎC4·|Åã¥Ü­«½Æ
EX:A2Äæ»PA4Ä椺®e¬Û¦P¥BB2Äæ»PB4Äæ¬Û¦P,C2¤ÎC4·|Åã¥Ü­«½Æ
2.§Æ±æ¥i¥H®Ú¾Ú¤ÀÃþªíªºª¬ªp±NBÄæ¤À°t¦ÜD,E,F,G,H¨Ã¥B¼Æ¶q°µ¬Û¥[
EX:B2Ä椺®eÂà´«¬°D2Åã¥Ü4,E2Åã¥Ü3,F2Åã¥Ü5,G2Åã¥Ü2,H2Åã¥Ü4

´ú¸Õ±M¥Î.rar (7.31 KB)

¥»©«³Ì«á¥Ñ ML089 ©ó 2017-8-28 18:03 ½s¿è

¦U¥_¤¤«n°Ï¼Æ¶q¬Û¥[.rar (8.93 KB)

­«½ÆÀˬd
C2 =COUNTIFS(A:A,A2,B:B,B2)

¥_¤¤«nªF¦U°Ï¼Æ¶q
D2 {=SUM(--IF(ISERROR(FIND(J$15:J$21,$B2)),0, TEXT(LEFT(TEXT(MID($B2&"X",FIND(J$15:J$21,$B2)+LEN(J$15:J$21)+1,{2,3,4,5,6}),),{1,2,3,4,5}),"[<>];;0;!0")  ))
¥k©Ô¤U©Ô¡A°}¦C¤½¦¡{...}

J$15:J$21 ¬O¥_¤¤«nªF³¡¦U¿¤¥«¦WºÙ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD