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

[µo°Ý] ­pºâ½Ð°²®É¼Æ

[µo°Ý] ­pºâ½Ð°²®É¼Æ

§Ú·Q¥Î¤GºØ¤£¦Pªº¤èªk­pºâC2:F9ªºÀx¦s®æ,¨C­Ó¤Hªº½Ð°²®É¼Æ,½Ð°Ý­n¨Ï¥Î­þºØ¨ç¼Æ¸û¦n? ÁÂÁÂ!
a)²Ö­p­Ó¤H½Ð°²®É¼Æ       
b)¨C¤H¦W¦rªº³Ì«á¤@Äæ,¤~­pºâ½Ð°²Á`®É¼Æ
½Ð°²³æ-2012_²Ö­p.zip (7.7 KB)

¦^´_ 1# PJChen

F2=SUMPRODUCT(($A$2:A2=A2)*($C$2:E2))
G2=IF(A2=A3,"",LOOKUP(2,1/($A$2:$A$9=A2),$F$2:$F$9))

TOP

¦^´_ 2# register313

½Ð°ÝG2­Y¤£­n§Q¥ÎFÄæ¦ì¨Ó¥[Á`,¬O§_¦³¨ä¥L¤è¦¡¥i¥Î?
G2=IF(A2=A3,"",LOOKUP(2,1/($A$2:$A$9=A2),$F$2:$F$9))

TOP

¦^´_ 3# PJChen

F2=SUMPRODUCT(($A$2:A2=A2)*($C$2:E2))
G2=IF(A2=A3,"",LOOKUP(2,1/($A$2:$A$9=A2),$F$2:$F$9))
G2=IF(A2=A3,"",SUMPRODUCT(($A$2:A2=A2)*($C$2:E2)))

TOP

¦^´_ 4# register313

­ì¨Ó­n®M¥Î¤W­±ªºSUMPRODUCT¨ç¼Æ.ÁÂÁÂ!

TOP

¦^´_ 5# PJChen

G2=IF(ROW()=LOOKUP(2,1/($A$2:$A$9=$A2),ROW($A$2:$A$9)),SUMPRODUCT(($A$2:A2=A2)*$C$2:E2),"")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂ謉¤À¨É...¦³§A¯u¦n¡IÁÂÁ¤F¡I
Supgirl

TOP

ÁÂÁ¤À¨É¡A¥¿»Ý­n³o­Ó~~~¦^´_ 1# PJChen

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD