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

[µo°Ý] ¦p¦ó±N¸ê®Æ¹LÂo«áª½±µ§e²{¦b¥t¤@­Ó¤À­¶

[µo°Ý] ¦p¦ó±N¸ê®Æ¹LÂo«áª½±µ§e²{¦b¥t¤@­Ó¤À­¶

¤½¥qªº³øªí¥i¥H¶×¥X¦¨EXCELÀÉ
¦ý³q±`¥²¶·¸g¹L¾ã²z¤â°Ê¿z¿ï§R°£«á
¤~¯à­ç°£¤£»Ý­nªº°T®§Äæ¦ì

·Q½Ð±Ð¦pªG °²³]¶×¥Xªº­ì©l¸ê®Æ¬° [Sheet1]
­n¦p¦ó¦b·s¶}ªº [Sheet2] ¤¤¯àª½±µ¿z¿ï±o¨ì ¦p¨Ò¹Ï¤¤ªº®ÄªG

[¨Ò¹Ïªº¿z¿ï±ø¥óÁ|¨Ò¦p¤U]
1. «~¦W«eºÝ¨S¦³*¦r¸¹ªº ¤@«ß«O¯d
2. ¦³*¦r¸¹  ¦ý®w¦s¶q¤£¬°0 ¤]¤@«ß«O¯d(§Y¨Ï¬O­t¼Æ)
3. ¥u§R°£ ¦³*¦r¸¹ ¥B®w¦s¶q¬°0ªº«~¶µ
4. ¨Ã¥B¦b³Ì²×¥u¯d¤U»Ý­nªº¶µ¥Ø (¼t°ÓÄ椣»Ý­n¬G§R°£)

¥Ø«e­Y­n¾ã²z¦¨³o¼Ë
§Ú¥u¯à¥ý±N«~¦W±Æ§Ç Åý¦³*¦r¸¹ªº«~¦W±Æ¦b¤@°_
µM«á¦A¥h°w¹ï¦³*¦r¸¹ªº«~¶µ ¦A¦¸®Ú¾Ú®w¦s¶q¦A±Æ§Ç ¦A§R´î
³Ì«á¤~¬O§R°£¥Î¤£¨ìªºÄæ¦ì¸ê®Æ
¹ê¦b¬Oı±o®Ä²v¤í¨Î

­º¦¸µo¤å ¦pªG»Ý¨Dªí¹F¤£²M ÁٽШ£½Ì


EXCEL-QA1.rar (2.97 KB)

SHEET2.B3: °}¦C¤½¦¡
=INDEX(Sheet1!B:B,SMALL(IF((LEFT(Sheet1!$C$3:$C$99&"*")="*")*(Sheet1!$D$3:$D$99=0),4^8,ROW($3:$99)),ROW(A1)))&""

¥k©Ô/¤U©Ô

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD