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

·j´M¸ê®Æ

·j´M¸ê®Æ

¥»©«³Ì«á¥Ñ Qin ©ó 2013-5-22 21:33 ½s¿è

¤d¦hµ§¸ê®Æ·j´M,½Ð°Ý­n¤U¦ó¨ç¼Æ
°ÝÃD:
TK_GB12
VK
TK_GB11

¸ê®Æ:
­I¤ß_15x25cm(TK_GB12)Each
ªø¿Ç_11x34.5cm(TK_GB3)Each
µu¿Ç_5x6.5cm(VK)Each
­I¥]_14.5x16cm(VK)Each
Á¢µ·¸È_24x1.5cm(TK_GB12)Each
¤Ø_2x1.5cm(TK_GB11)Pcs

¦p¦ó§â¦³" TK_GB12, "VK", "TK_GB11"ªº¦r¦ê,¥þ³£·j´M¥X¨Ó.
µª®×:
­I¤ß_15x25cm(TK_GB12)Each
Á¢µ·¸È_24x1.5cm(TK_GB12)Each
µu¿Ç_5x6.5cm(VK)Each
­I¥]_14.5x16cm(VK)Each
¤Ø_2x1.5cm(TK_GB11)Pcs

¦^´_ 1# Qin

­n§äªº¤º®e©ñA¦C¡A³Q§äªº©ñB¦C
C1°}¦C¤½¦¡
  1. =IF(SUM(--ISNUMBER(SEARCH(OFFSET($A$1,,,COUNTA(A:A),),B1))),B1,"")
½Æ»s¥N½X
¤U©Ô¡AµM«á¦A²¾°£­«½Æ(¥Î¤½¦¡ªº¸Ü·|¤ñ¸ûºC)

·j´M¸ê®Æ_sol.rar (97.11 KB)

TOP

[ª©¥DºÞ²z¯d¨¥]
  • Hsieh(2013-5-24 16:07): EXCEL2003¥²¶·¥[¸ü¤ÀªR¤u¨ã½c¼W¯q¶°

¦^´_ 2# Bodhidharma

«x¡Aexcel2003¦ü¥G¤£¯à¨Ï¥Îrandbetween
©Ò¥H»Ý­n§ârandbetween(1,5000)§ï¬°int(rand()*5000)+1
·j´M¸ê®Æ_sol.rar (89.27 KB)

TOP

¥[­Ó¡e§Ç¸¹¡f¤½¦¡¬°»²§UÄæ¡A§Q¥Î²³æªº¤½¦¡§Y¥i¨ú¥Xµ²ªG¡A
¥H´X¤dµ§¸ê®Æªº·j´M³t«×À³©|¯à±µ¨ü¡A¥ß§Y¿é¤J¡D¥ß§YÅã¥Üµ²ªG¡AÃöÁä¦r¹w³]¢¸­Ó¡A¥i¦Û¦æ¦A¼W¥[¡I
¤U¸üÀÉ¡Ghttp://www.funp.net/89936

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD