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

PJChen

§Ú·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)

¤U¸ü¦¸¼Æ: 19

2012-2-4 16:21

register313

¦^´_ 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))

PJChen

¦^´_ 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))

register313

¦^´_ 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)))

PJChen

¦^´_ 4# register313

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

Hsieh

¦^´_ 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),"")

¤p¤k¤l

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

funny2255

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