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

[µo°Ý] ½Ð°Ý §ì¸ê®Æ°ÝÃD

[µo°Ý] ½Ð°Ý §ì¸ê®Æ°ÝÃD

¦U¦ì¥ý¶i¦n
¦bexcel¤¤ ¦pªG ¦³ 1-500  °²³]  ±q20¶}©l§ì ¥]§t 20 °_ 100­Ó 储¦s®æ
°µ¤@¦¸ ÁÙ¦n ¥i¬O ­n°µ«Ü¦h¦¸ ¦Ó¥B ¨C¦¸ªº°_ÀY³£¤£¤@¼Ë ¦³¥i¯à 15 ¶}©l ¦ý¬O ¸ê®Æ³£¤@¼Ë
¨º¦³¨ä¥Lªº¤è¦¡¥i¥H¨Ï¥Î¶Ü?
°£¤F¥Î©Ôªº¤è¦¡
¦]¬° ¦pªG­n°µ100¦¸ ´N­n©Ô100¦¸?
·PÁ¦U¦ìªº¸Ñµª

¦^´_ 1# 15390807


    ¨º­n¬Ý°_ÀY¼Æ­È¦³¬Æ»ò¼Ëªº³W«h?
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 1# 15390807

°²³]¦³ 1-100¸ê®Æ

A2:A101 =¸ê®Æ1 - ¸ê®Æ100

D1, ¬O¼Æ¾ÚÅçÃÒ(data validation) ¤U©Ô¦Cªí

D2, ¤½¦¡ :

=IFERROR(INDEX(A$2:A$101,D$1+ROWS(A$1:A1)-1),"")

¤½¦¡¦V¤U½Æ»s

³æÀ»D1¿ï¾Ü ¸ê®Æ°_©l¸¹½X

JBYT1.rar (9.1 KB)

TOP

¦^´_  15390807

°²³]¦³ 1-100¸ê®Æ

A2:A101 =¸ê®Æ1 - ¸ê®Æ100

D1, ¬O¼Æ¾ÚÅçÃÒ(data validation) ¤U ...
JBY µoªí©ó 2012-10-20 14:09


¸ê®ÆÅçÃÒ, ²M³æ =10,20,30,40,50,60,70,80,90

TOP

¸ê®ÆÅçÃÒ, ²M³æ =10,20,30,40,50,60,70,80,90
JBY µoªí©ó 2012-10-20 20:24



  D1,   ¸ê®ÆÅçÃÒ, ²M³æ:  10,20,30,40,50,60,70,80,90

TOP

[ª©¥DºÞ²z¯d¨¥]
  • Hsieh(2012-10-22 14:09): ½Ð¤W¶Ç§AªºÀÉ®×»¡©ú

­ì¨Ó §Ú°Ý±o¤ÓÅ¢²Î¤F ¹ï¤£°_  ª½±µ»¡®æ¦¡À³¸Ó·|¤ñ¸û¦n£t?
AÄæ ¬°¤é´Á BÄæ ¬° ¼Æ¾Ú   
°²³]  §Ú·Q­n 2012/10/21 ¶}©l «e200µ§BÄ檺¸ê®Æ ¥i¥H¥Î©Ôªº¤@¦¸´N¦n¤F
¦ý¬O ¦pªG­n«Ü¦h¦¸  ¥i¬O ¨C¦¸¶}©lªº°_©l¤é³£¤£¤@¼Ë ¦ý¬O ©¹«e ³£¬O©T©w200µ§
¤]´N¬O ¤U¤@¦¸¥i¯à 2012/10/10 ©¹«e200µ§
¦A¨Ó 2012/01/01 ©¹«e200µ§
¤é´Áªº®É¶¡§Ç¦C¬°¥æ©ö¤é
¦pªG­n°µ 200¦¸ ´N­n©Ô200¦¸¤F  ¨º¦³¤èªk¥i¥H¸`¬Ù®É¶¡¶Ü? ·PÁ¦U¦ìªº¦^µª

TOP

¦^´_ 7# 15390807

°²³] A1:B1001, AÄæ ¬°¤é´Á,  BÄæ ¬° ¼Æ¾Ú1-1000

D1, ¸ê®ÆÅçÃÒ, ²M³æ: =$A$201:$A$1001

D2, 阵¦C¤½¦¡ :

{=IFERROR(INDEX(B$2:B$1001,MATCH(2,1/(A$2:A$1001=D$1))-200+ROWS(A$1:A1)),"")}

阵¦C¤½¦¡¦V¤U½Æ»s

³æÀ»D1¿ï¾Ü ¸ê®Æ°_©l¤é´Á
JBYT1-R1.rar (20.7 KB)

JBYT1-R1.rar (20.7 KB)

TOP

        ÀR«ä¦Û¦b : ¦Y­W¤F­W¡B­WºÉ¤Ü¨Ó¡A¨ÉºÖ¤FºÖ¡BºÖºÉ´d¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD