Hsieh

¦^´_ 3# basarasy

{=INDEX(A:A,SMALL(IF(MATCH(A$2:A$100&"",A$2:A$100&"",)=ROW($2:$100)-1,ROW($2:$100),4^8),ROW(1:1)))&""}
    ¦¹¤½¦¡¸ê®Æ½d³ò¬OA2:A100
§A¥i®M¥Î¬Ý¬Ý±N$A$2:$A$100§ï¦¨§Aªº¸ê®Æ½d³ò$D$3:$D$40
{=INDEX(A:A,SMALL(IF(MATCH($D$3:$D$40&"",$D$3:$D$40&"",)=ROW($3:$40)-1,ROW($3:$40),4^8),ROW(1:1)))&""}

basarasy

ÁÂÁ Hsieh©Mzz5151353ª©¥D.
§Ú¤£¯à¤U¸ü><

³o­Ó¦pªG­n«ü©w¦a¤è  D3:D40  ½Ð°Ý­n¦pªG§ï?
{=INDEX(A:A,SMALL(IF(MATCH(A$2:A$100&"",A$2:A$100&"",)=ROW($2:$100)-1,ROW($2:$100),4^8),ROW(1:1)))&""}

zz5151353

¤£¿ù
¤p§Ì¤]¨Ó¼ö¾x¤@¤U

{=INDEX(A:A,SMALL(IF(MATCH(A$2:A$100&"",A$2:A$100&"",)=ROW($2:$100)-1,ROW($2:$100),4^8),ROW(1:1)))&""}