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

[µo°Ý] ¬Û¦P¨âÄæ¦ì(¦hµ§¼Æ)¥[Á`¦b²Ä1µ§¦ì¸m

[µo°Ý] ¬Û¦P¨âÄæ¦ì(¦hµ§¼Æ)¥[Á`¦b²Ä1µ§¦ì¸m

°ÝÃD¡A¤w±Æ§Ç¦n¸ê®Æ¡A¦ý»Ý­n±N¬Û¦Pªº¨âÄæ¸ê®Æ¡A¥[Á`¦b¤@°_¡A¨Ã©ñ¦b²Ä¤@µ§ªº¦ì¸m¡A­Y¥¼¬Û¦P­È´Nª½±µ©ñ¨ì¹j¾ÀÄæ¦ì¡C

°ÝÃD71¬Û¦P¨âÄæ¦ì(¦hµ§¼Æ)¥[Á`¦b²Ä1µ§¦ì¸m.rar (8.52 KB)

§Æ±æ¤ä«ù!

¦^´_ 1# s7659109


    D2=IF(ROW()=LOOKUP(1,1/($A$2:$A$28&$B$2:$B$28=A2&B2),ROW($A$2:$A$28))-COUNTIFS($A$2:$A$28,A2,$B$2:$B$28,B2)+1,SUMPRODUCT((($A$2:$A$28&$B$2:$B$28)=(A2&B2))*$C$2:$C$28),"")
©Î¨Ï¥Î¼Ï¯Ã¤ÀªRªí
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¸Ñ¨M¤F¡AÁÂÁ¡C
§Æ±æ¤ä«ù!

TOP

=IF(COUNTIFS(A$2:A2,A2,B$2:B2,B2)=1,SUMIFS(C$2:C$28,A$2:A$28,A2,B$2:B$28,B2),"")
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD