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

[µo°Ý] °ÊºA¨â¼h¤U©Ô¦¡¿ï³æ

¥»©«³Ì«á¥Ñ Hsieh ©ó 2014-8-8 16:12 ½s¿è

¦^´_ 7# bridetobe
§â¸ê®Æ®wÂà¸m§@¹ï·Óªíªº§@ªk¨Ã¤£¬O¦n¤èªk
¦A»¡¨º»ò¦h©w¸q¦WºÙ·|²Ö¦º¤H(¨C¼W¼t°Ó´N­n¼W¥[¦WºÙ)
±N«~¶µ²M³æ¸ê®Æ¥HAÄæ§@±Æ§Ç
§â²Ä3­Ó¤u§@ªí±Ë±ó¡A«Ø¥ß¥H¤U4­Ó¦WºÙ
a=OFFSET(«~¶µ²M³æ!$A$2,,,COUNTA(«~¶µ²M³æ!$A:$A)-1,)
s=COUNTA(a)
x=OFFSET(«~¶µ²M³æ!$B$1,MATCH(±ÄÁÊ©ú²Ó!$E2,«~¶µ²M³æ!$A:$A,0)-1,,COUNTIF(«~¶µ²M³æ!$A:$A,±ÄÁÊ©ú²Ó!$E2),)
¼t°Ó¦W=OFFSET(«~¶µ²M³æ!$H$2,,,65536-COUNTBLANK(«~¶µ²M³æ!$H:$H)-1,)
ª½±µ¦b«~¶µ²M³æ¤u§@ªíH2¿é¤J°}¦C¤½¦¡
=IF(ROW(±ÄÁÊ©ú²Ó!A1)>SUM(1/COUNTIF(a,a)),"",INDEX(a,SMALL(IF(COUNTIF(OFFSET(INDEX(a,1,1),,,ROW(INDIRECT("A1:A"&s)),),a)=1,ROW(INDIRECT("A1:A"&s)),""),ROW(±ÄÁÊ©ú²Ó!A1))))
¤U©Ô¦Ü¥X²{ªÅ¥Õ
±ÄÁÊ©ú²ÓEÄæÅçÃÒ
=¼t°Ó¦W
±ÄÁÊ©ú²ÓFÄæÅçÃÒ
=x
    ±ÄÁÊªí³æ.zip (27.09 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD