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

[µo°Ý] ­ì¦³¤u§@ªí¤¤¤£¦PÄæ¦ì¸ê®Æ¡AÂಾ¨ì·s²£¥Í¤u§@ªí¤¤¡A¥u¬D¥X»Ý­nªºÄæ¦ì

[µo°Ý] ­ì¦³¤u§@ªí¤¤¤£¦PÄæ¦ì¸ê®Æ¡AÂಾ¨ì·s²£¥Í¤u§@ªí¤¤¡A¥u¬D¥X»Ý­nªºÄæ¦ì

·Q½Ð°Ý¨Ì¤U¤j¤j
§Ú·Q±N§Ú²Ä¤@­Ó¬¡­¶ªº¸ê®Æ
Âà´«¦¨²Ä¤G­Ó¬¡­¶ªº®æ¦¡
½Ð°Ý¸Ó¦p¦ó°µ
ÁÂÁÂ
«æ
·P®¦ ±M®×®w¦s©ú²Ó±b2010.rar (188.71 KB)

B3=INDEX('²Ä 1 ­¶ (2)'!A:A,SMALL(IF('²Ä 1 ­¶ (2)'!$A$2:$A$20000='²Ä 1 ­¶ (2)'!$A$7,ROW($A$1:$A$19999),60000),ROW(A1)))    °}¦C¤½¦¡
¦V¥k¦V¤U COPY   ¨Ã¾A·í½Õ¾ã¦ì¸m

TOP

¦^´_ 2# ANGELA


    ¤j¤j§Ú¥Î±zªº°}¦C¤½¦¡
¥i¬O±a¥X¨Óªºµ²ªG«o¬O0¡A¬O§Ú­þÃä§Ë¿ù¤F¶Ü?
AÄ檺 ±M®×¦WºÙ¸ê®Æ¤]¥i¥H¦Û°Ê±a¥X¨Ó¶Ü?
ÁÂÁÂ

TOP

°}¦C¤½¦¡ªº¿é¤J­nCTRL,SHIFT,ENTER¤TÁä¦P®É«ö,¤½¦¡·|¦Û°Ê²£¥Í¤j¬A¸¹¥]¦í¤½¦¡.

TOP

¦^´_ 3# bobby0204
¤j¤j~§Úªº·N«ä¬O°µ¦¨¦V¤U¹Ïªº®æ¦¡

TOP

¦^´_ 5# bobby0204
¤j¤j½Ð°Ý¨Ì¤U
B3=INDEX('²Ä 1 ­¶ (2)'!A:A,SMALL(IF('²Ä 1 ­¶ (2)'!$A$2:$A$20000='²Ä 1 ­¶ (2)'!$A$7,ROW($A$1:$A$19999),60000),ROW(A1)))
¦pªG§Úªº¸ê®Æ¼W¥[®É
²Ä 1 ­¶ (2) AÄ檺¸ê®Æ±Æ¨ì²Ä63869Äæ¡A§Ú¤½¦¡¸Ó¦p¦ó­×§ï¡A
§ÚÁÙ¦³¤@­Ó°ÝÃD
ªþ¥ó¤¤ E118Äæ ³o¶µ¥Øo °µ¤F2¦¸ I°µ¤F1¦¸
¥i¬O§Ú¤½¦¡¶]¥X¨Ó
¥u¦³¤@¦¸O¤@¦¸I

TOP

a3=IF(SMALL(IF(ISNUMBER(FIND("±M®×",'²Ä 1 ­¶ (2)'!$A$1:$A$65000)),ROW($A$1:$A$65000),65536),COUNTA($A$2:$A2)-COUNTBLANK($A$2:$A2)+2)<SMALL(IF('²Ä 1 ­¶ (2)'!$A$2:$A$65001='²Ä 1 ­¶ (2)'!$A$7,ROW($A$1:$A$65000),60000),ROW(A1)),INDEX('²Ä 1 ­¶ (2)'!A:A,SMALL(IF(ISNUMBER(FIND("±M®×",'²Ä 1 ­¶ (2)'!$A$1:$A$65000)),ROW($A$1:$A$65000),9000),COUNTA($A$2:$A2)-COUNTBLANK($A$2:$A2)+2)),"")
¥Î°}¦C¤½¦¡Á٥Ψì6¸U¦C·|Åý¤Hµ¥ªº¤£­@·Ðªº,ÁÙ¬O¨ìvba°Ï¥h¨D§U§a.

TOP

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD