ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¦p¦ó¦b¬Y­Ó°Ï°ì¸Ì­±´M§ä¤å¦r

¦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)

¦^´_ 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¤½¦¡

TOP

¦^´_ 2# ML089


«D±`ÁÂÁ±zªº¸Ñµª¡A¦pªG§Ú·Q­nÅܦ¨±qÀx¦s®æ¸Ì­±´M§ä"¨ä¤¤ªº"¯S©w¤å¦r©O¡H
¨Ò¡G
­ì¥»B2 ¬O "ABCDE5-3"  Åܦ¨ B2¬O "[EQP]=ABCDE5-3"
·Q§äªº¤è¦¡¬O¡G¥u­n¨ä¤¤¤å¦r¦³¥]§t¨ì ABCDE5-3  ´N¦n

TOP

¦Û°Ý¦Ûµª¤@¤U...
­è­è¦Û¤v´ú¸Õ¥X¨Ó¡A¥i¥H¥Î
=COUNTIF(RAW!X:AH,"*"&A2)
¨Ó°µ¨ì¡AÁÂÁ ML089 ¤j¤j~

TOP

¦^´_ 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)))

TOP

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

TOP

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD