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

sugotw

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

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

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

¤u§@ªí2

¤U¸ü (20.29 KB)

2014-12-22 11:17

¤u§@ªí1

¤U¸ü (29.17 KB)

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

sugotw

¦^´_ 5# p212

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

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

p212

¦^´_ 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

p212

¦^´_ 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

sugotw

¦^´_ 2# p212

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

ªþ¤W½d¨ÒEXCEL


    Test.rar (7.08 KB)

¤U¸ü¦¸¼Æ: 5

2014-12-22 14:40

p212

¦^´_ 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