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

[µo°Ý] ²£«~ºØÃþªí,¸ê®Æ¶¶§Ç¤Î±Æ¦C

¦^´_ 18# ANGELA


    §Ú¤]§V¤Oªºª§¨ú§ó¦h¤À¼Æ,§Æ±æ¦¨¬°(¤¤¾Ç¥Í)!!!!
excel~ ¾Ç¦n¥L§a

TOP

G5=IF($E5="","",OFFSET(Sheet2!$A$1,MAX((Sheet2!$A$1H$874=$E5)*ROW($A$1A$874))-1,COLUMN()-7,,))
...
ANGELA µoªí©ó 2010-11-24 11:40



    ¨Ï¥Î¤F³o¤½¦¡~¦ý¦pªGSheet2 ¤ºA¦C¨S¦³­È,¦ýB/C¦C¦³~¦p¦ó¥O¨ì Sheet1³£¥i¥HÅã²{¥X©O??
excel~ ¾Ç¦n¥L§a

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD