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

[µo°Ý] Ãö©óÀx¦s®æ¸ê®ÆÂ^¨ú»PÂà´«

[µo°Ý] Ãö©óÀx¦s®æ¸ê®ÆÂ^¨ú»PÂà´«

¦U¦ì¤j¤j¦n:
·Q½Ð±Ð¤@­Ó°ÝÃD
§Ú¦³¤@¥÷¸ê®Æ¨â­ÓSheet
¸ÌÀY¦³sheet1¦³1~2500µ§ªº¸ê®Æ
»Ý­nÂà´«¦¨Sheet2ªº§Î¦¡
§Ú¥Ø«e¬O¥ÎOFFSETªº¨ç¼Æ
¦ý¬O¦³­Ó°ÝÃD
·í§Ú§R°£¤FSheet1ªº³æµ§©Î³¡¤À¸ê®Æ«á
§Ç¸¹´N·|¿ù¶Ã¤F¡ã¡ã¡ã¡ã¡ã
¨Ò¦p¡G§Ú§R°£¤FSheet1ªº§Ç¸¹2ªº¸ê®Æ
Sheet2ªºA501¸ê®Æ·|±Æ¨ì501¨S¿ù
¦ý¬OD2ªº¸ê®Æ´N·|¿ù¤F¡ã¡ã¤´µM¬O§Ç¸¹501

ÁöµM¬O1¡ã2500µ§
¦]¬°¸Ì­±¦³¨Ç§Ç¸¹¬O¤£­nªº¡Ö¡@¡@¡@¡Õ
½Ð°Ý¤j¤j­Ì³o¦³¤°»ò¤è¦¡©Î¬O¨ä¥Lªº¨ç¼Æ¥i¥H¸Ñ¨M§R°£¸ê®Æ«áÅý§Ç¸¹¥¿±`±Æ¦Cªº¿ìªk»ò¡H¡H
¤£µM¡ã§Ú·|±Æ¨ìºÆ±¼
¦b¦¹¤]ªþ¤W§Ú¥Ø«e°µªºÀɮסã
ÁٽЦU¦ì°ª¤â¤j¤j¯à¨ó§U
¦b¦¹¥ýÁÂÁ¦U¦ì¤j¤j¤F¡ã¡ã¡ã

·s¸ê®Æ§¨.rar (43.19 KB)

¤£¯à¦b½s¿è¤F¡ã¡ã¡ã
§Ú¤W²îµL¤ùÅý¤j¤j­Ì¬Ý¬Ý¦n¤F¡ã

1.JPG (28.94 KB)

1.JPG

2.JPG (184.6 KB)

2.JPG

3.JPG (39.92 KB)

3.JPG

4.JPG (76.82 KB)

4.JPG

5.JPG (111.18 KB)

5.JPG

·s¸ê®Æ§¨.rar (43.49 KB)

TOP

³o¬O§A­nªºµ²ªG¶Ü?

TOP

§Ú§â¤½¦¡¨q¥X¨Ó¡A¥ªÃä¬O§R°£«e¡A¥kÃä¬O§R°£«á¡A§A¥i¥H¬Ý¨ìÀx¦s®æ¤ºªº¤½¦¡ÅܤÆ
PS¡G¤W­±¨º½gªº¹Ï¤º¤½¦¡¥´¿ù¤F¡A³o±i¤~¹ï

TOP

¥»©«³Ì«á¥Ñ dodo234 ©ó 2015-4-19 11:58 ½s¿è

·PÁÂtyrone123456¤jªº´£¨Ñ
¦ý¬O§Ú·Q°µ¦¨ªº¬O¡]¦p¹Ï¡^
¥ªÃä¬O§R°£«e¡ã¥kÃä¬O§R°£«á³o¼Ëªº¼Ë¦¡
¤£ª¾EXCEL¦bÂ^¨ú¸ê®Æ¤W¥i¥H°µ¨ì³o¼Ë»ò¡H¡H¡H¡H
¥t¥~¡ã¤£ª¾¯à§_®M¥Î¦bOFFSETªº¨ç¼Æ¸Ì©O¡H¡H¡H
©ÎªÌ¬O§ÚÂ^¨ú¸ê®Æªº¨ç¼Æ¥Î¿ù¤F¡Ö¡@¡@¡Õ
¥D­n§Ú¬O·Q±N2500µ§¤@ªø¦êªº¸ê®Æ
®i¦¨¤@±iªí³o¼Ë¤ñ¸û¦n¤ñ¹ï
¦ý¬O³o³s¸¹ªº¸ê®Æ¤¤¤S¤£¬O©Ò¦³¸ê®Æ¬O§Ú­nªº¡ã¡ã¡ã¡ã

111.JPG (15.65 KB)

111.JPG

TOP

§Aªº»Ý¨D¥²¶·¼gVBAµ{¦¡¤~¯à¹F¨ì¡A
¦]¬°·í§A§R°£¬Y¤@¸ê®Æ¤§«á¡A¥L·|¥X²{¤@°T®§°Ý§A­n¥kÃä©Î¤U­±ªº¸ê®Æ²¾¹L¨Ó¡A¦ý¬O²¾°Ê¹L¨ÓªºÀx¦s®æ¤º¨ÃµL¥ô¦ó¤½¦¡¡A©Ò¥H®Ú¥»¤£¥i¯à°µ¥X¥ô¦ó°Ê§@¡A©ÎªÌ§A¥h§R°£­ì©l¸ê®Æªº¦ì¸m¡A¦ý¦¹³BªºÀx¦s®æ¤½¦¡·|¦Û°ÊÅܧ󤽦¡¡A©Ò¥H¤]¨S¦³¿ìªk¹F¨ì§Aªº¥Ø¼Ð¡A¬G¦¹§Ú¤~»¡¼gVBAµ{¦¡¤~¯à¹F¨ì§Aªº¥Øªº

TOP

·Q¨ì¼gªk¤F
¥ª°Ï¬O°²³]­ì©l¸ê®Æ¡A¤¤¶¡¬OÅܧ󪺱ƦC¼Ë¤l¡A¥kÃä«h¬O§â¤½¦¡Åã¥Ü¥X¨Ó¡A¨ä¤¤³Ì«á¤@­Ó¤½¦¡¦h¥[¤J§PŪ¦¡¬O¦]¬°­YµL¼Æ­È«hÅã¥ÜªÅ¥Õ


§A¸Õ¸Õ§R°£¤@µ§®Æ¡A´N·|¦p§A·Q­nªº§ïÅÜ

TOP

¦^´_ 7# tyrone123456
tyrone123456±z¤Ó¯«¤F¡ã¡ã¡ã¡ã
¦¨¥\¤F­C¡ã¡ã¡ã¡ã^O^
¦ý¦]¬°§Ú¹ïOFFSET¨ç¼Æ¥Îªk¤£¬O«ÜÁA¸Ñ¡ã
¥i§_¤è«K»P¸ß°Ý
±z©Ò³]©wªº
=OFFSET($A$2,ROW(I2)-2,0,1,1)»P
=IF(OFFSET($A$2,ROW(I14)-2,0,1,1)>0,OFFSET($A$5,ROW(I14)-2,0,1,1),"")
¤º®e¬O¤°»ò·N«ä©O¡H
§Ú·Q»¡­Y§ÚÁA¸Ñ¸Ì­±ªº³]©w¡ã¥H«á¤]³\¥i¥H¦A§ó¬¡¥Î¤F¡ã¡ã¡ã
¯uªº¤ÓÁÂÁÂtyrone123456¤jªº¤j¤O¨ó§U¤F¡ã
2500µ§ªºªí®æ²×©ó¦n¤F¡ã¡ã¡ã¡ã¡ã

TOP

§A¸Õ¸Õ¬Ý§â§Ú­è­è¨qªº¸ê®Æ¦A§R°£¨âµ§¡A§A´N·|¬Ý¨ì¤£¥[ifªº®t²§
¨S¦³ifªº¸Ü¡A§A·|¬Ý¨ìG5Àx¦s®æÅã¥Ü0¡A´N¤£¦n¬Ý¡A­Y¥[¤Wif¡A«h¥i¥H±Nµ¥©ó0ªºÀx¦s®æÅܦ¨ªÅ¥Õ¡A­¶­±¬Ý°_¨Ó´N·Pı¦n¦h¤F

TOP

¦^´_ 9# tyrone123456
®@¡I¡I¡I­ì¨Ó¦p¦¹¡ã¡ã
tyrone123456±z¯u²Ó¤ß¡ã·Q¨ì±N­¶­±¬ü¤Æ¡ã¡ã¡ã¡ã
§Ú¥i¥H¦A°Ý±z
=OFFSET($A$2,ROW(I2)-2,0,1,1)
¸ÌÀYªºROW(I2)-2,0,1,1­n«ç»ò¸ÑÄÀ»ò¡H¡H¡H
¥t¥~§Ú·Q°Ý¤@¤UROW(I2)-2³o¹Bºâ¦¡¬O«ç¼Ë¤~¯àª¾¹Dªº©O¡H¡H
¦]¬°§Ú¨C¦¸¼g³o³¡¥÷³£¼g¤£¦n¡ã¤£ª¾¹D«ç»ò¼g¤~¯à§ì¨ì§Ú­nªº¸ê®Æ¡Ö¡@¡@¡Õ
¥i§_¤è«K¦A±Ð±Ð§Ú.......

TOP

        ÀR«ä¦Û¦b : ¥ÌÄ@°µ¡BÅw³ß¨ü¡C
ªð¦^¦Cªí ¤W¤@¥DÃD