½d³ò¦WºÙ¸Ìªº°Ñ·Ó¥i®Ú¾ÚÀx¦s®æÅܰʶܡH
- ©«¤l
- 15
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 57
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- 32bit
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2011-11-17
- ³Ì«áµn¿ý
- 2013-9-12
|
½d³ò¦WºÙ¸Ìªº°Ñ·Ó¥i®Ú¾ÚÀx¦s®æÅܰʶܡH
¥»©«³Ì«á¥Ñ alhuang88888 ©ó 2011-11-20 16:56 ½s¿è
½Ð°ÝExcel°ª¤âÌ¡A
¦b³]©w°ÊºA¦WºÙ®É¡A§Úªº°Ñ·Ó¸Ì±¥]§t¤@Ó¨ç¼Æ¬OMATCH(Sheet1!A1,Sheet10!$B:$B,0)¡A
¦pªG§Ú¬O¦bSheet1¸Ì±¡AÀx¦s®æÂI¿ï¨ìA3®É¡A°Ñ·Óªº¨ç¼Æ¬O·|ÅÜMATCH(Sheet1!A3,Sheet10!$B:$B,0)¡A¥i¬O¦pªG§Ú²{¦b²¾¨ìSheet3¸Ì±¡AÀx¦s®æ°²¦p²¾°Ê¨ìA5®É¡A°ÊºA¦WºÙ°Ñ·Óªº¨ç¼Æ¬OÅÜMATCH(Sheet1!A5,Sheet10!$B:$B,0)¡AMATCH¤´µM¹ïÀ³ªº¬OSheet1¡A
½Ð°Ý¦³¿ìªk²{¦b¬O¦bSheet3¸Ì¡AÀx¦s²¾°Ê¨ìA5®É¡A°ÊºA¦WºÙ°Ñ·Óªº¨ç¼Æ¥i¥HÅÜMATCH(Sheet3!A5,Sheet10!$B:$B,0)¶Ü¡H
ÁÙ¬O§Ú¤@©wn¨CÓSheet³£¦³¤@Ó¿W¥ßªº°ÊºA¦WºÙ©O¡H
·PÁ±z¸ÑŪ°ÝÃD¸òªá®É¶¡¸Ñµª~ |
|
|
|
|
|
|
- ©«¤l
- 1572
- ¥DÃD
- 16
- ºëµØ
- 2
- ¿n¤À
- 1521
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2016-1-13
|
=MATCH(!$A1,Sheet10!$B:$B,0)
«e±¥u©ñÅå¹Ä¸¹¡AÁÙ¦³¬°¦ó§Aªº»¡©ú¤@·|Sheet10¡A¤@·|Sheet2 |
|
|
|
|
|
|
- ©«¤l
- 15
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 57
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- 32bit
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2011-11-17
- ³Ì«áµn¿ý
- 2013-9-12
|
¦^´_ 2# oobird ÁÂÁ´£¿ô¸òÀ°¦£¡A§Ú¤w¸g×¥¿§Úªº°ÝÃD¸Ì¥´¿ùªº¦r¡C§ó§ï¤§«á¤S¾Ç²ß¨ì¤@½Ò~
|
|
|
|
|
|
|