- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2014-12-16 10:29 ½s¿è
¦^´_ 3# ©P¤j°¶
¡u¦h±ø¥óªº¬d¸ß¡v¨Ï¥Î©w¸q¦WºÙ»P°}¦C¤½¦¡¸Ñ¨M¡A½Ð°Ñ¨£ªþ¥ó¡C
»¡©ú¡G
©w¸q¦WºÙ¡u½s¸¹¡v¡A°Ñ·Ó¨ì¿é¤J=OFFSET(¤u§@ªí2!$A$2,,,COUNTA(¤u§@ªí2!$A:$A)-1)¡C
©w¸q¦WºÙ¡u©m¦W¡v¡A°Ñ·Ó¨ì¿é¤J=OFFSET(¤u§@ªí2!$D$2,,,COUNTA(¤u§@ªí2!$D:$D)-1)¡C
©w¸q¦WºÙ¡u¦a§}¡v¡A°Ñ·Ó¨ì¿é¤J=OFFSET(¤u§@ªí2!$E$2,,,COUNTA(¤u§@ªí2!$E:$E)-1)¡C
¤u§@ªí1¤§Àx¦s®æO2¿é¤J°}¦C¤½¦¡ (¥HCtrl+Shift+Enter¿é¤J)
=IF(J2="","",IFERROR(INDEX(¦a§},MATCH(1,(½s¸¹=A2)*(©m¦W=J2),0)),""))
¦V¤U½Æ»s¤½¦¡
(½s¸¹=A2)*(©m¦W=J2)±ø¥ó§¹¥þ¦¨¥ß®É·|¶Ç¦^ True (¹Bºâ®Éµø¬°1)¡A¤Ï¤§¶Ç¦^ False (¹Bºâ®Éµø¬°0)¡C |
|