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

[µo°Ý] Excel ·s¤â½Ð±Ð°ÝÃD

¦^´_ 9# blithely1017


±Y¼ì§Ú¹J¨ì§xÃø¡A¥u¯à´Á«Ý¨ä¥L«e½úÀ°¦£
¤£ª¾¹D¬°¤°»òÀx¦s®æ§Ú¤w¸g³]©w¬°ªÅ¥Õ
­ì¥»·Q¥Îctrl+G§ìªÅ¥Õ µM«á¥kÁä§R±¼¡AÀx¦s®æ©¹¤W²¾
¦ý¬Octrl+g §ìªÅ¥Õ®É«o§ì¤£¥X¨Ó

data.rar (22.01 KB)

TOP

¦^´_ 1# blithely1017


  §Ú­è­è·Q¨ì¤@­Ó¤èªk
´N¬O­n¥ý±NG:H½Æ»s¶K¤W¨ì¥t¤@­Ó¤u§@ªí
¦A±NG:HÄæ¦ì¥þ¿ï¡A¨Ã¨Ï¥Î²¾°£­«ÂÐ

§Æ±æ³o¼Ë¬O§A­nªº

TOP

¦³¦hµ§¸ê®Æ(½s¸¹¡B³W®æ¡B·Å«×¡BData)¡A¤@­Ó½s¸¹·|¦³¤TºØ³W®æ¡A¬O§_¥i¥H¥Î¤½¦¡±N»Ý­nªº±ø¥ó(N­Ó)¨ú¥X(½s¸¹¡B ...
blithely1017 µoªí©ó 2016-8-4 16:07



    µ²ªG­¶ ¥Î°}¦C¤½¦¡§@¤F¥Ü½d¡A¨ä¥L¥i¦Û¦æ°Ñ¦Ò¼gªk¶ñ¤J«á¤U©Ô
    ¼Ï¯Ãµ¹2ºØ°Ñ¦Ò¡A¶K¤J¸ê®Æ«á´N·|¦Û°Ê²£¥Í¡A¦pªG¤é«á¸ê®Æ·|Åܦh¡A¥i¥H °ÊºA½d³ò ³B²z

data_with AF&Pivot.zip (33.94 KB)

TOP

¦^´_ 13# KCC

½Ð°Ý§Ú§ó§ï±ø¥ó¡A¦ýÅã¸Õµ²ªG¿ù»~¬O¤°»ò­ì¦]

Data.rar (140.69 KB)

TOP

¥»©«³Ì«á¥Ñ KCC ©ó 2016-8-11 13:57 ½s¿è

¦^´_ 14# blithely1017


    ¦Ü¤Ö§ì¨ì¹Ï»¡©ú¤@¤U¿ù»~§a¡AÁÙ­n§O¤H¹ï¥b¤Ñ¥h²q
    ¦Û­q¤@­Ó·s¦WºÙ
    TT=COUNTA(TRxData[Serial Number]) ¡A¥Î¨Óºâ¥X½d³ò¤º¦³´Xµ§¡A¦A®M¨ì«áÄò¤½¦¡¡A¤~¯à§ì¨ì²Ä100µ§¥H«áªº¸ê®Æ
    DATA­¶¡A¤½¦¡À°§A¤p½Õ¤@¤U
    b5={IFERROR(INDEX(INDIRECT("TRxData["&B$4&"]"),SMALL(IF((TRxData[Voltage (v)]=$B$3)*(TRxData[Temp]=$C$3),ROW(INDIRECT("$1:$"&TT))),ROW(A1))),"")}
   ¥k©Ô¡A¤U©Ô
   ¦¹¤½¦¡°w¹ïb5¡A´«§@¨ä¥L±ø¥ó®É¡A¹ïÀ³®æ¦ì­n¦Û¦æÅܧó

   ¥t¥~¡A«Ç·Å¡B§C·Å¡B°ª·Å ­ì©l¸ê®Æ«á­±¦³²§±`¤£¦P¼Æ¶qªÅ¥Õ¡A³o¼Ëªº¸ê®Æ¤£¦n......

TOP

¦^´_ 15# KCC
sorry, {:3_60:}
·PÁÂKCC¤j¤j¡A«üÂI°g¬z¡C

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD