- ©«¤l
- 3
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 13
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-1-24
- ³Ì«áµn¿ý
- 2013-1-31
|
¦^´_ 1# keovin790916
½T»{¤@¤U¡A¬On¥Î¥kÃ䪺¸ê®Æ¬°¥D¡AÅã¥Ü¦b¥ªÃä¸ê®Æªº¤ñ¹ïµ²ªG¶Ü¡H
§Ú¥Î¤@¦æ»²§U¸ê®ÆÅý±zÅý®e©öÀ´¡A¦bCÄæ¿é¤J=A1&"-"&B1 ©¹¤U©Ô(¦hÓ-¬O¬°¤F°Ï¤ÀA©MBªº¸ê®Æ)
µM«á§ä±znÅã¥ÜªºÄæ1¿é¤J=IF(NOT(ISERROR(MATCH(D1&"-"&E1,C:C,0))),"§¹¥þ¥¿½T",IF(NOT(ISERROR(MATCH(D1,A:A,0))),"³¡¤À¥¿½T","µL¦¹¸ê®Æ"))
°Ñ¦Ò¬Ý¬Ý^^ |
|