¦p¦ó¦b¬YÓ°Ï°ì¸Ì±´M§ä¤å¦r
- ©«¤l
- 16
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 28
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-8-31
- ³Ì«áµn¿ý
- 2019-5-17
|
¦p¦ó¦b¬YÓ°Ï°ì¸Ì±´M§ä¤å¦r
¦p¹Ï¸ÑÄÀ¡G
§Ú·Q¦bsheet1 ´M§ä¯S©w¤å¦r¡A§ä¨ì«á¦b¡y¬O§_³B²z¡z¨ºÃ䥴¤WV¡A¦pªG«á±¦³¤å¦rªº¸Ü¡A¶¶«K¦b¡y»¡©ú¡z¨ºÃä±a¥X
½Ð°Ý¸Ó«ç»ò¥Î©O¡H(excel ª©¥» 97-2003)

TEST.rar (3.54 KB)
|
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
     
|
¦^´_ 1# sworder12
B2 =COUNTIF(¤u§@ªí1!A:C,A2)
C2 =IF(B2,INDIRECT("¤u§@ªí1!"&TEXT(MAX((A2=¤u§@ªí1!$A$1:$C$9)*(ROW($1:$9)*10^3+COLUMN(B:D))),"!R0!C000"),0)&"","")
C2¿é¤J¤½¦¡»Ý¥Î¤TÁä¿é¤J(CTRL+SHIFT+ENTER ¤TÁä»ô«ö¿é¤J) |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 16
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 28
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-8-31
- ³Ì«áµn¿ý
- 2019-5-17
|
¦^´_ 2# ML089
«D±`ÁÂÁ±zªº¸Ñµª¡A¦pªG§Ú·QnÅܦ¨±qÀx¦s®æ¸Ì±´M§ä"¨ä¤¤ªº"¯S©w¤å¦r©O¡H
¨Ò¡G
쥻B2 ¬O "ABCDE5-3" Åܦ¨ B2¬O "[EQP]=ABCDE5-3"
·Q§äªº¤è¦¡¬O¡G¥un¨ä¤¤¤å¦r¦³¥]§t¨ì ABCDE5-3 ´N¦n |
|
|
|
|
|
|
- ©«¤l
- 16
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 28
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-8-31
- ³Ì«áµn¿ý
- 2019-5-17
|
¦Û°Ý¦Ûµª¤@¤U...
èè¦Û¤v´ú¸Õ¥X¨Ó¡A¥i¥H¥Î
=COUNTIF(RAW!X:AH,"*"&A2)
¨Ó°µ¨ì¡AÁÂÁ ML089 ¤j¤j~ |
|
|
|
|
|
|
- ©«¤l
- 161
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-9-16
- ³Ì«áµn¿ý
- 2017-2-19
|
¦^´_ 1# sworder12
C2:
=IF(B2="","",IFERROR(VLOOKUP(A2,¤u§@ªí1!A$1:B$9,2,0),VLOOKUP(A2,¤u§@ªí1!B$1:C$9,2,0))) |
|
|
|
|
|
|
- ©«¤l
- 1399
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1409
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2025-2-20

|
http://blog.xuite.net/hcm19522/twblog/361570249
°Ñ¦Ò |
|
|
|
|
|
|