- ©«¤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-5-27 11:17 ½s¿è
¦^´_ 1# pupai
1¡BÀx¦s®æH2줽¦¡ =IF(COUNTIF(¸ê®Æ!$A:$A,$A2),VLOOKUP($A2, ¸ê®Æ!$A:$AT,COLUMN(I2),),"")
IÄæ´¡¤JÄæ¦ì«á·|Åܦ¨=IF(COUNTIF(¸ê®Æ!$A:$A,$A2),VLOOKUP($A2, ¸ê®Æ!$A:$AT,COLUMN(J2),),"")
HÄæ¸ê®Æ¤@©w·|¶]±¼
2¡B¡u¹L±b¡v¤u§@ªí¤§Àx¦s®æB2¿é¤J
=IFERROR(INDEX(¸ê®Æ!Print_Area,MATCH($A2,¸ê®Æ!$A:$A,0),MATCH(B$1,¸ê®Æ!$1:$1,0)),"")
¦V¤U¦V¥k½Æ»s¤½¦¡
3¡B¡u¹L±b¡v¤u§@ªí¤§¡u(·s)³æ»ù¡vÄæ¦ì¤£¦b¡u¸ê®Æ¡v¤u§@ªí¤º¡A¬GµL¸ê®Æ¥i¹ïÀ³¡C
4¡B¡u¹L±b¡v¤u§@ªí»P¡u¸ê®Æ¡v¤u§@ªí¤ºªºÄæ¦ì¦WºÙ§¹¥þ¬Û¦PªÌ¡A«h¥i¹ïÀ³¥X¸ê®Æ¡A¥B¤£¨ü´¡¤JÄæ¦ì¼vÅT¡C
½Ð°Ñ¦Ò¡I |
|