¦p¦ó¥ÎEXCEL§ì¨úºô¶¤Wªº¸ê®Æ¨Ã¤ÀÃþ
- ©«¤l
- 10
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 57
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2019-5-20
- ³Ì«áµn¿ý
- 2020-7-29
|
¦p¦ó¥ÎEXCEL§ì¨úºô¶¤Wªº¸ê®Æ¨Ã¤ÀÃþ
javascript:;
½Ð°Ýºô¶¤jPªø³o¼Ë
¥i¥H¥ÎEXCEL§ì¨ú¤U¨Ó
Åý¥L¤À§OÅã¥Ü±ø¦C¤À©ú¶Ü
§Ç¸¹¡B«È½s¡B³æ¸¹¡B¹q¸Ü¡B¦a§} |
¬£¤u¨t²Î
|
|
|
|
|
|
- ©«¤l
- 10
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 57
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2019-5-20
- ³Ì«áµn¿ý
- 2020-7-29
|
¦^´_ 1# GXSP
¦bºô¶¤W½Æ»sª½±µ¶K¨ìexcel
µM«á¦b²Ä2±i¤u§@ªí
¥Î¨ç¼Æ=IFERROR(INDEX(¤u§@ªí1!$A:$F,MATCH(A2,¤u§@ªí2!$A:$A,0)+1,1),"")
IFERROR(__,"")¬OÅýN/A¤£Åã¥Ü
INDEX(___,___,____)¬d¸ß½d³ò¬O¤u§@ªí1ªºA~FÄæ,¦^¶Ç²ÄO¦C,¦^¶Ç²ÄOÄæ)
§ÚÅý¥L§PÂ_ §Ç¸¹:?¤À§O¦b¨º¨Ç¦C¡CµM«á¬Ýn¦^¶Çþ¤@¦Cþ¤@Äæ¦b¤â°Ê¥[¤W¥h
¶]¬O¶]¥X¨Ó¤F
¨D¸Ñ1
¹q¸Ü¦³®ÉÔ·|¥X²{¥u¦³1°¦¹q¸Üªº ·|¨Ï¨ç¼Æ°õ¦æ«á¹q¸Ü¤U±ªº¨ä¥LÄæ¦ì¶]±¼(EX:©m¦W¶]¥h«È½s)
¨D¸Ñ2
¦³¨ä¥L§ó¦nªº°µªk¶Ü |
|
|
|
|
|
|
- ©«¤l
- 10
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 57
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2019-5-20
- ³Ì«áµn¿ý
- 2020-7-29
|
쥻ªº¨D¸Ñ1 §ä¥X¥H¤U¤èªk
¦b¤u§@ªí2ªºAÄæ´¡¤J»²§UÄæ123456......999
F2¿é¤J¥H¤U¤½¦¡
=IFERROR(INDEX(¤u§@ªí1!$A:$F,SMALL(IF(ISERROR(MATCH(¤u§@ªí1!$A:$A,$F$1,0)),"",ROW(¤u§@ªí1!$A:$A)),A1),2),"")
¦C¼Æ¶Ã¶]ªº°ÝÃD §Ú¥Î»²§UÄæ+small¦^¶Ç²Än¦C¼Æ¸Ñ¨M¤F
¦ý¬O¤½¦¡¦n¹³¤Óªø ¾ãÓexcelÅÜ«Ü¥d¡A¹y¡A·í
½Ð°Ý¦³§ó¦nªº¸Ñ¨M¿ìªk¶Ü |
|
|
|
|
|
|
- ©«¤l
- 10
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 57
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2019-5-20
- ³Ì«áµn¿ý
- 2020-7-29
|
$A:$A
©Ò¦³AÄ檺¹Bºâ¶q¤Ó¤j
§ó§ï¬°
$A1:$A9999 «á¸Ñ¨M!! |
|
|
|
|
|
|