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

±ø¥ó¶ë¿ï«á¡A±N¸ê®Æ½Æ»s¨ì¯S©wÄæ¦ìªº¤èªk?

¥»©«³Ì«á¥Ñ p212 ©ó 2014-12-22 12:08 ½s¿è

¦^´_ 1# sugotw
1.¿ï¨ú¤u§@ªí2¤§A1:D5¡A«öCtrl+Shift+F3¡A¥H¡u³»ºÝ¦C¡v¬°¦WºÙ¡A¤À§O©w¸q¡u½s¸¹¡v¡B¡u¦WºÙ¡v¡B¡u¼Æ¶q¡v»P¡u®w¦s¡v¡C
2.©ó¤u§@ªí1
(1)Àx¦s®æG2¿é¤J°}¦C¤½¦¡ (¥HCtrl+Shift+Enter¿é¤J)
=IFERROR(INDEX(¼Æ¶q,MATCH(1,(½s¸¹=A2)*(¦WºÙ=B2),0)),"")
¦V¤U½Æ»s¤½¦¡
(2)Àx¦s®æH2¿é¤J°}¦C¤½¦¡
=IFERROR(INDEX(®w¦s,MATCH(1,(½s¸¹=A2)*(¦WºÙ=B2),0)),"")
¦V¤U½Æ»s¤½¦¡
½Ð°Ñ¦Ò¡I

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-12-22 15:24 ½s¿è

¦^´_ 3# sugotw
½T»{2#¥\¯à¥¿±`µL»~¡I
Àx¦s®æG2»PÀx¦s®æH2¬Ò¬°°}¦C¤½¦¡¡A ½Æ»s2#ªº¤½¦¡¶K¤W«á¥²¶·¦P®É«ö¤UCtrl+Shift+Enter¤TÁä¿é¤J¤½¦¡¡A½Ð°Ý±z¬O¦p¦¹°õ¦æ¡H

fig.jpg (51.73 KB)

fig.jpg

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-12-22 15:37 ½s¿è

¦^´_ 3# sugotw
­Y¤u§@ªí2ªº¸ê®Æ±N·|¦V¤UÂX¼W¡A«h«Øij­×§ï¦U©w¸q¦WºÙªº°Ñ·Ó¤½¦¡¡G
½s¸¹¡A¨ä¡u°Ñ·Ó¨ì¡v­×§ï¬° =OFFSET(¤u§@ªí2!$A$2,,,COUNTA(¤u§@ªí2!$A:$A)-1)
¦WºÙ¡A¨ä¡u°Ñ·Ó¨ì¡v­×§ï¬° =OFFSET(¤u§@ªí2!$B$2,,,COUNTA(¤u§@ªí2!$B:$B)-1)
¼Æ¶q¡A¨ä¡u°Ñ·Ó¨ì¡v­×§ï¬° =OFFSET(¤u§@ªí2!$C$2,,,COUNTA(¤u§@ªí2!$C:$C)-1)
®w¦s¡A¨ä¡u°Ñ·Ó¨ì¡v­×§ï¬° =OFFSET(¤u§@ªí2!$D$2,,,COUNTA(¤u§@ªí2!$D:$D)-1)
½Ð°Ñ¦Ò¡I

fig2.jpg (56.37 KB)

fig2.jpg

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD