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

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

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

¤j®a¦n¡A¤pªº¬O­èµù¥Uªº·|­û¡A½Ð¤j®a¦h¦h«ü±Ð

·Q½Ð°Ý³o¸Ìªº°ª¤â

¤U¹Ï¬O¤u§@ªí2©M¤u§@ªí1ªº¤º®e

¤u§@ªí2
¹Ï¤ù 000.jpg
2014-12-22 11:17


¤u§@ªí1
¹Ï¤ù 001.jpg
2014-12-22 11:19


¦³¨S¦³¤èªk¥i¥H·í¤u§@ªí2ªºA¡BB¨âÄæ²Å¦X¤u§@ªí1ªºA¡BB¨âÄæ«á

±N¤u§@ªí2ªºC¡BD¨âÄæ½Æ»s¨ì¤u§@ªí1ªºG¸òH

¥»©«³Ì«á¥Ñ 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

¦^´_ 2# p212

·PÁ¦^´_¡A¦ý¬O¤p§Ì·Ó§Aªº¤èªk¿é¤J¤½¦¡¨S¦³§@¥Î

ªþ¤W½d¨ÒEXCEL


    Test.rar (7.08 KB)

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

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

TOP

¦^´_ 5# p212

¥i¥H°Ê§@¤F¡A«D±`·PÁÂ

¤Ö°µ¤FCtrl+Shift+Enterªº°Ê§@¡A¯uºF·\...

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD