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

¦p¦ó¦bEXCEL¤º·j´M¯S©wªº¦r¦ê

¦p¦ó¦bEXCEL¤º·j´M¯S©wªº¦r¦ê

¦p¦ó¦bEXCEL¤º·j´M¯S©wªº¦r¦ê

½Ð°Ý¦U¦ì°ª¤â..........

­n¾ã²z¤@¥÷¸ê®Æ
¸Ì­±¦³«Ü¦h±b¸¹¨Ò¦p¬O 4098777 50777456 4798222 1010000

¨º¦pªG§Ú·Q·j´M¯S©w±b¸¹¸Ì­±¤T¥|½X¬°98ªº³o¨Ç±b¤á

¤£ª¾¹D­n«ç¼Ë³B²z¤~¯à§â³o¨Ç¯S§Oªº±b¤á³æ¿W¦C¥X¨Ó©O

ÁÂÁ ·P®¦¡I

¥»©«³Ì«á¥Ñ p212 ©ó 2013-12-30 16:59 ½s¿è

¦^´_ 1# la1975
½Ð°Ý±zªº¸ê®Æ¦p¦ó¤À¥¬¡H(¦p1#©Ò¦C4098777 50777456 4798222 1010000¤À§O¬°4­ÓÀx¦s®æªº¸ê®Æ¡H§í¬°1­Ó¦r¦ê¡H)
¥i¥H¤W¶Ç½d¨ÒÀÉ¡HÁÂÁ¡I

TOP

¨Ï¥Î CTRL + F ¬d¸ß
¿é¤J: ??98*
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# p212

¨Ñ°Ñ.rar (2.15 KB)

TOP

¦^´_ 4# la1975


    D2=IF(IFERROR(SEARCH("98",A2),0)>0,ROW(),"")
    C2 ÁÙ­n¦b·Q·Q .....
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 4# la1975

E2 ¥i¥H²¤Æ
E2 =IF(ROW(A1)>COUNT(D:D),"",INDEX(A:A,SMALL(D:D,ROW(A1))))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¶â¡I §Ú¸Õ¸Õ  ÁÙ¦³¨ä¥L¤èªk¶Ü¡H

TOP

¦^´_ 7# la1975
D2 =IF(MID(A2,3,2)="98",MAX(D$1:D1)+1,"")
E2 =IF(ROW(A1)>COUNT(D:D),"",INDEX(A:A,MATCH(ROW(A1),D:D,)))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD