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

EXCEL ¨ç¼Æ ¬D¥X¤£­«ÂЭÈ

EXCEL ¨ç¼Æ ¬D¥X¤£­«ÂЭÈ

¦U¦ì¦n !

§Ú¦³¤@­Ó°}¦Cªº¨ç¼Æ·Q­n½Ð±Ð
INDEX(A:A,SMALL(IF(MATCH($A$1:$A$8,$A$1:$A$8,0)=ROW($1:$8),ROW($1:$8),4^8),ROW(1:1)))&""

¥H¤Wªº¨ç¼Æ, ­Y¸ê®Æ©T©w¦bA1~A8, ¨º¬O¨S¦³°ÝÃDªº,   ¦ý§ÚA¦æªº¸ê®Æ³£¤£¤@©w, ¦³®É·|¨ì10­Ó,  ¦³®É·|20­Ó,
§Ú¥i¥H«ç»ò­×¥¿¤W­zªº¨ç¼Æ©O?  ÅýA¦æ¤£ºÞ¥X²{´X­Ó¸ê®Æ, ³£¥i¥H¶¶§Qªº§ä¥X¤£­«ÂЭÈ!


·PÁ¤j®a, ½Ð¤j®a¦hÀ°¦£!

¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-7-28 00:09 ½s¿è

©w¸q¦WºÙ ZZ
¤½¦¡ =OFFSET($A$1,,,COUNTA($A:$A)-1)

{=INDEX(A:A,SMALL(IF(MATCH(ZZ,ZZ,)=ROW(ZZ),ROW(ZZ),4^8),ROW(1:1)))&""}
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 2# zz5151353

>> ©w¸q¦WºÙ ZZ
>> ¤½¦¡ =OFFSET($A$1,,,COUNTA($A:$A)-1)

§Ú¬Ý­ì¦¡¨ÃµLªíÀY¡AÀ³¸Ó¤£¥Î´î 1
©w¸q¦WºÙ ZZ
¤½¦¡ =OFFSET($A$1,,,COUNTA($A:$A))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

GOOD THX
NICE CODE
¡ä_¡ä

TOP

        ÀR«ä¦Û¦b : ±o²z­nÄǤH¡A²zª½­n®ð©M¡C
ªð¦^¦Cªí ¤W¤@¥DÃD