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

[Âà¶K] °Q½×¤£­«½Æ²M³æ

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-6-30 22:23 ½s¿è

ÁÂÁ 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)))&""}
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2010-7-1 08:24 ½s¿è

¦^´_ 4# Hsieh

¹Ï1 d5·|¦³ ªÅ®æ   ¤½¦¡{=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)))&""}

¹Ï2 ¨S¦³¥X¼Æ  ¤½¦¡{=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)))&""}
zz1.JPG
zz2.JPG
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2010-7-1 08:23 ½s¿è

¦^´_ 6# zz5151353

ÁÂÁÂzz¤j¤j.
¤j¤j±Ðªº³o­Ó¨S¦³°ÝÃD¤F.
{=INDEX(D:D,SMALL(IF((D$3:D$40<>"")*MATCH(D$3:D$40&"",D$3:D$40&"",)=ROW($3:$40)-2,ROW($3:$40),4^8),ROW(1:1)))&""}
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD