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

[µo°Ý] ½Ð°Ý¦p¦ó¨ÏVLOOKUP·j´M­È¬Û¦P¡A¦ý·j´Mµ²ªG¤£¦P(¤w¸Ñ¨M)

[µo°Ý] ½Ð°Ý¦p¦ó¨ÏVLOOKUP·j´M­È¬Û¦P¡A¦ý·j´Mµ²ªG¤£¦P(¤w¸Ñ¨M)

¥»©«³Ì«á¥Ñ yeeki ©ó 2012-5-25 18:04 ½s¿è

¤j®a¦n¡A
§Ú·Q¥ÎVLOOKUP§â¤u§@ªí¡u¦W³æ¡v¤¤¥]¬ASMSÃþ§OÄ椺¥]¬A¡uam¡vªº¦C¸ê®ÆÅã¥Ü¦b¤u§@ªí¡uAM-SMS¡vªº¤u§@ªí¤¤¡K¡K
¦ý¬O§Ú¥ÎVLOOKUPªº¸Ü¡A©Ò¥H¦C³£¥u·|Åã¥Ü²Ä¤@µ§ªºam¸ê®Æ¡A½Ð°Ý§Ú¥i¥H¥Î¬Æ»ò¤èªk¨Ï©Ò¦³am¸ê®Æ³£Åã¥Ü¥X¨Ó¡K¡K

³o¬O¡u¦W³æ¡vªº¤u§@ªí


³o¬O¡uAM-SMS¡vªº¤u§@ªí(§Ú·Q­nªºµ²ªG)

¦^´_ 1# yeeki

AM-SMS¤u§@ªí
A2=INDEX(¦W³æ!A:A,SMALL(IF(¦W³æ!$A$2:$A$10000="AM",ROW($A$2:$A$10000),65536),ROW(A1)))&""    °}¦C¤½¦¡
¥k©Ô¤U©Ô

TOP

¦^´_ 2# register313


    ·P½Ð±zªº¦^ÂСA
§Ú¦bEXCEL¤¤¨Ï¥Î¤½¦¡®É¡A¥u¦³²Ä1µ§¸ê®Æ¦¨¥\Åã¥Ü¥X¨Ó¡A¥Ñ²Ä3¦C¶}©lÀx¦s®æ´NÅã¥Ü#NUM!
¥t¥~¡A¦pªG§ÚªºSMSÃþ§O¤£¬O¦bAÄæ¦Ó¬O¦bEÄ檺¸Ü¡A¬O¤£¬O¥u­n§â¡u¦W³æ!A:A¡v©M¡u¦W³æ!$A$2:$A$10000¡v§ï¬°¡u¦W³æ!E:E¡v©M¡u¦W³æ!$E$2:$E$10000¡v´N¥i¥H¡H

ÁÂ~

TOP

¦^´_ 3# yeeki

AM-SMS¤u§@ªí
A2=INDEX(¦W³æ!A:A,SMALL(IF(¦W³æ!$E$2:$E$10000="AM",ROW($A$2:$A$10000),65536),ROW(A1)))&""    °}¦C¤½¦¡(¿é¦n¤½¦¡­n«öCTRL+SHIFT+ENTER¦Ó¤£¬Oª½±µ«öENTER)
¥k©Ô¤U©Ô

TOP

¦^´_  yeeki

AM-SMS¤u§@ªí
A2=INDEX(¦W³æ!A:A,SMALL(IF(¦W³æ!$E$2E$10000="AM",ROW($A$2A$10000), ...
register313 µoªí©ó 2012-5-25 10:20



    ±z¦n¡A
°ÝÃD¤w¸g¸Ñ¨M¡A¤½¦¡¨S¦³°ÝÃD¤F~
¥t¥~§Ú·Q°ÝSMALL(IF(¦W³æ!$E$2:$E$10000="AM",ROW($A$2:$A$10000),65536),ROW(A1))¡A¤¤ªº¡u65536¡v¬O¦³¬Æ»ò§@¥Î©O¡H
ÁÂ~

TOP

½Ð°ÝA2=INDEX(¦W³æ!A:A,SMALL(IF(¦W³æ!$A$2:$A$10000="AM",ROW($A$2:$A$10000),65536),ROW(A1)))&""   
ªº¤½¦¡­n¦p¦ó¸ÑŪ

TOP

¦^´_ 6# age54321


    A2=INDEX(¦W³æ!A:A,SMALL(IF(¦W³æ!$A$2:$A$10000="AM",ROW($A$2:$A$10000),65536),ROW(A1)))&""   
³Ì¥~¼h¬OINDEX¨ç¼Æ¤¤¶¡¬OSMALL¤º¼h¬OIF²z¸Ñ°_¨ÓÀ³¤£Ãø
¤@¯ë¸ûªøªº¤½¦¡¥i¦b½s¿è¦C¤¤¥Ñ³Ì¤º¼h¤½¦¡¥Î·Æ¹«¤Ï¥Õ«á«öF9¦A©¹¥~©µ¦ù¥iª¾¤½¦¡¦p¦ó§@¥Î
IF(¦W³æ!$A$2:$A$10000="AM",ROW($A$2:$A$10000),65536)
°²¦pA2¨ìA10000ªº­Èµ¥©ó"AM"´Nµ¹2:10000ªº­È,§_«hµ¹65536 (65536¬OAÄæ³Ì«á¤@­Ó¦ì¸m)
SMALL(IF(¦W³æ!$A$2:$A$10000="AM",ROW($A$2:$A$10000),65536),ROW(A1))
IF¤½¦¡¤¤©Ò±o¨ìªº°}¦C¨ú²Ä´X¤pªº­È(¨ÌROWªº¦ì¸m¨M©w¨ú­È)

TOP

¼Ó¥D~ ¨ä¹ê¥Î¼Ï¯Ã¬O¤£¬O§ó¤è«K©O???
´£¨Ñ§A¥t¤@ºØ«äºû~
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD