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

½Ð±Ð¤@­ÓIF¤p°ÝÃD

½Ð±Ð¤@­ÓIF¤p°ÝÃD

¥»©«³Ì«á¥Ñ smking0204 ©ó 2012-2-22 00:41 ½s¿è

B1 =¼Æ¦r1, B2 = ¼Æ¦r2.....B50 = ¼Æ¦r50
C1¨ìC50¤£ª¾¹D­þ´X®æ¬°ªÅ¥Õ

¤]´N¬O¦bC1µo²{¨S¸ê®Æ ´N§âB1ªº¸ê®Æ¼g¤J¨ìA1
¦bC5µo²{¨S¸ê®Æ ´N§âB5ªº¸ê®Æ¼g¤J¨ìA2
¦bC7µo²{¨S¸ê®Æ ´N§âB7ªº¸ê®Æ¼g¤J¨ìA3
¦bC9µo²{¨S¸ê®Æ ´N§âB9ªº¸ê®Æ¼g¤J¨ìA4

AÄæ¨Ì§Ç©¹¤U ¨S¦³ªÅ®æ




¥H¤W ³Â·Ð¤j®v¸Ñ±Ï°Õ

=IF(C1=0,B1,"")
danny

TOP

¦^´_ 1# smking0204

A1=IF(INDEX($C$1:$C$50,ROW()*2-1,1)="",INDEX($B$1:$B$50,ROW()*2-1,1),"")

TOP

danny001 ¨º¤è¦¡µLªk±Æ§Ç
register313 ¤£ª¾¹D¬°¤°»ò ³o¤è¦¡¦³¿ù ÁÙ¬O¨S¦³±Æ§Ç ¦Ó¥B¿z¿ï¥X¨Ó¦³¿ù

TOP

¥»©«³Ì«á¥Ñ register313 ©ó 2012-2-22 23:38 ½s¿è

¦^´_ 4# smking0204

¤£¤F¸Ñ¦ó³B¿ù»~,
¦ý¬O§Ú¦Û¦æ§ï¤F­Ó¦a¤è,C3
C1=""  B1 ¼g¨ìA1
C3=""  B3 ¼g¨ìA2
C5=""  B5 ¼g¨ìA3
C7=""  B7 ¼g¨ìA4


ÁÙ¦³³o»P±Æ§Ç ¿z¿ï¦³¦óÃö³s
¥i§_§@­Ó½d¨Ò¦A»¡©ú²M·¡§A­nªº¥\¯à

TOP

¦^´_ 1# smking0204

A1°}¦C¤½¦¡=IF(ROW(A1)>COUNTBLANK($C$1:$C$25),"",INDIRECT("B"&SMALL(IF($C$1:$C$25="",ROW($B$1:$B$25),""),ROW(A1))))
¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Hsieh ¤j¤jªº¤½¦¡¬O¹ïªº­ò~ (¦³´ú¸Õ¹L)
register313 ¤j¤jªº¤½¦¡·|¸õ®æ~ A2 ·|¬OªÅªº~
¥H¤U¬O¨â­Ó°õ¦æ«áªº¹Ï¤ù

¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

¥»©«³Ì«á¥Ñ register313 ©ó 2012-2-23 11:27 ½s¿è

¦^´_ 7# hugh0620

1.§Ú¥H¬°¥u¦Ò¼{C1 C3 C5 C7...©_¼Æ¦C(¦]¼Ó¥DÁ|¨Ò¬Ò¬°1 3 5 7 ©_¼Æ¦C)
2.¥¼ª`·N¨ìAÄ椣­nªÅ¥Õ
¬Ý¤FHsieh¶Wª©¤§¸Ñµª«á,ª¾¹D¼Ó¥Dªº·N«ä¤F

TOP

¦^´_ 8# register313


    ­Ó¤H¦b²q¼Ó¥D­nªº¬O¥u­nCÄ椤¦³ªÅ¥Õ~
    ´N¥ÎBÄæ¦ì¦P¤@¦Cªº¸ê®Æ¶ñ¨ìAÄæ¦ì~
    ¥B³o¼Ë¤]¤ñ¸û²Å¦X¹ê»Ú¤WªºÀ³¥Î~
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

Hsieh¤j¤j¬O¥Î°}¦C¤½¦¡ªº°ª¤â©O
¦n§Æ±æ¥i¥H¸ò¥L¾Ç²ß
jeason

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD