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

[µo°Ý] À³¥Î¤U©Ô¿ï³æ§ä¹ïÀ³¸ê®Æ

[µo°Ý] À³¥Î¤U©Ô¿ï³æ§ä¹ïÀ³¸ê®Æ

½Ð°Ý¦bA2¡BB2¦³°µ¤U©Ô¿ï³æ¡A·í§Ú¿ï¨ú¹ïÀ³¤§ªk±ø¦WºÙ¤Î±ø¤å«á¡A­n¦p¦ó³]©w¤~¯à®Ú¾Ú©Ò¿ï±ø¤å¡A¦Û°Ê±q¸ê®Æ®wùاä¥X¹ïÀ³ªº«O¦s¦~­­©M³Ì­«¥»¦D?ÁÂÁ¡I


¤U©Ô¿ï³æ.zip (7.47 KB)

¦^´_ 1# aer


    ¤p§Ì¥u¯à°µ¥X³o¼Ëªº§@«~¡A¨ä¥Lªº³¡¤À´N½Ð¨ä¥L¤j¤jÀ°¦£¤F¡C

20140123 2¼h¤U©Ô¿ï³æ - ¼´¥X¼Æ­È V.00.rar (4.46 KB)

TOP

I2Àx¦s®æ¤U©Ô¿ï³æ¡A±q¸ê®ÆÅçÃÒ-->¸ê®ÆÅçÃÒ-->²M³æ-->¨Ó·½
¿é¤J¡G¦Dªk±ø¤å,¬r«~±ø¤å
´N¥i¥H§ïµ½¤U©Ô¿ï¥X­«½Æ  ¦Dªk±ø¤å¤Î¬r«~±ø¤å

TOP

¦^´_ 3# jeffrey628litw

jeffrey628litw ÁÂÁ±z´£¨Ñªº¤èªk¡C¦¹¤èªk¥u·|Åã¥Ü¬r«~ªº±ø¤å¤Î¬ÛÃöªº¸ê®Æ¡A¦ý¬O¦Dªk±ø¤å¤Î«á­±ªº¸ê®Æ¡AµLªkÅã¥Ü¡A½ÐÀ°¦£ÁÂÁÂ!

TOP

¥»©«³Ì«á¥Ñ jeffrey628litw ©ó 2014-1-24 12:44 ½s¿è

¤j¤j¡A§Ú±N§Aªº¸ê®Æ®w­×§ï¤F¤@¤U¡A§A¬Ý³o¼Ë¦æ¤£¦æ?

20140124 2¼h¤U©Ô¿ï³æ - ¼´¥X¼Æ­È V.02.rar (4.5 KB)

TOP

¦^´_ 5# jeffrey628litw

ÁÂÁ±zªº¦^ÂСI¦ý¬O¡A§ÚÁÙ¬O§Æ±æ¥Î­ì¨Óªº¤è¦¡§e²{¤ñ¸û¤è«K¬d¸ß¡A¦]¬°¦³«Ü¦hºØÃþªº±ø¤å¥²¶·¤À¶}¬d¸ß¡A¥HÁקK²V²c

TOP

C2=OFFSET(INDIRECT(A2),,1,MATCH(B2,INDIRECT(A2),0),)
D2=OFFSET(INDIRECT(A2),,2,MATCH(B2,INDIRECT(A2),0),)

½Ð±Ð¦U¦ì¦Ñ®v¡A¬°¤°»ò§ÚC2¡BD2©Ò¿é¤Jªº¤½¦¡¤£·|¸òµÛA2¡BB2§ïÅܵ²ªG©O¡H¦Ó¬O©T©w¦b¦P¤@­Ó­È¡H­n¦p¦ó­×§ï¤~¯àÅý¥¦¸òÀHA2¡BB2ÅܤƩO¡HÁÂÁÂ

TOP

¦^´_ 1# aer

=VLOOKUP($B2,OFFSET(IF($A2="¦Dªk±ø¤å",¦Dªk±ø¤å,¬r«~±ø¤å),,,,3),COLUMN(B2),)
¤½¦¡¥k©Ô½Æ»s
   
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# aer

¦WºÙ­×§ï¦p¤U:
¦Dªk±ø¤å        =¸ê®Æ®w!$A$2:$C$13
¬r«~±ø¤å        =¸ê®Æ®w!$E$2:$G$12

C2¤½¦¡¥i¥H²¤Æ¦p¤U:       
C2 =VLOOKUP($B2,INDIRECT($A2),COLUMN(B2),)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 9# ML089

ÁÂÁª©¥D´£¨Ñªº¤èªk¡A¦ý¬O¦bB2ªº¤U©Ô¦¡¿ï³æ·|¥X²{©Ò©w¸q½d³òªº¥þ³¡¸ê®Æ¡A¦perr¹Ï¤ù¡A§Ú§Æ±æ¦p¥¿½Tªº¹Ï¤ùµ²ªG¡A¤£ª¾¹D¬O§_¥i¥H¹F¦¨¡H©Î¬O¥u¯à¥Îª©¥Dªº«Øij¤èªk©O¡H½Ð«ü±Ð¡AÁÂÁÂ



TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD