[µo°Ý] ±Æ¦W±Æ§Ç¤½¦¡

fantersy

±Æ¦W±Æ§Ç.rar (9.48 KB)

¤U¸ü¦¸¼Æ: 14

2015-1-14 11:28

¦pªþ¥ó
AÄ榳¶R¶i»P½æ¥X
BÄ榳¤ôªGºØÃþ
·Q½Ð°Ý¤@¤U¦³¦ó¤½¦¡
¥i¥H¤À§O­pºâ¶R¶i¸ò½æ¥Xªº±Æ¦W»P±Æ§Ç(¤ôªG¦WºÙ)
¤À§OÅã¥Ü¦bD»PEÄæ

¤p§Ì¤µ¤Ñ­è¦nº¡50¥i¥H¤U¸üÀɮפF

samwang

¦^´_ 1# fantersy

D2=IFERROR(INDEX($B:$B,SMALL(IF($A$1:$A$30=D$1,ROW($A$1:$A$30),),ROW(1:1)+COUNTIF($A$1:$A$30,"<>"&D$1)),),"")
    °}¦C¤½¦¡¡A©¹¥k©¹¤U

samwang

¦^´_ 2# samwang

D2=IFERROR(INDEX($B:$B,SMALL(IF($A$1:$A$30=D$1,ROW($A$1:$A$30),""),ROW(1:1)),),"")
    °}¦C¤½¦¡©¹¥k©¹¤U

p212

¦^´_ 1# fantersy
½Ð°Ý¹w´Áªºµª®×¦p¹Ï¥Ü¡H

fantersy

¦^´_ 4# p212


    p212¤j¤j§A¦n
¬Oªº~¨S¿ù~§Ú·Q­n§e²{´N¬O³o¼Ëªº¤è¦¡~ÁÂÁÂ!!

fantersy

¦^´_ 2# samwang


    samwang¤j¤j§A¦n
¨Ï¥Î§Aªº°}¦C¤½¦¡
±Æ§Çªº³¡¥÷§ÚÅã¥Ü¥X¨Óªº¬O¦³­«ÂЪº
¦p¤U!!
¶R¶i        ½æ¥X
Ä«ªG        Ä«ªG
Ä«ªG        Ä«ªG
Ä«ªG        ­»¿¼
­»¿¼        ­»¿¼
­»¿¼        ­»¿¼
¤õÀsªG        ­»¿¼

samwang

¦^´_ 6# fantersy

¨Ï¥Î§Aªº°}¦C¤½¦¡
±Æ§Çªº³¡¥÷§ÚÅã¥Ü¥X¨Óªº¬O¦³­«ÂЪº>>±Æ°£­«½Æ¦p¤U

D2=IFERROR(INDEX($B:$B,SMALL(IF(IFERROR(MATCH(D$1&$B$1:$B$30,$A$1:$A$30&$B$1:$B$30,),)=ROW(A$1:$A$30),ROW(A$1:$A$30)),ROW(A1))),"")
°}¦C¤½¦¡¡A©¹¥k©¹¤U©Ô

p212

¦^´_ 7# samwang
7#ªº¤½¦¡¥i­×§ï¬°¤U¦C°}¦C¤½¦¡
=IFERROR(INDEX($B$2:$B$30,MATCH(0,COUNTIF($C$1:C1,$B$2:$B$30),0)),"")
¦ý¦¹¨â­Ó¤½¦¡¶È¯à¨ú¥XBÄ檺¡u°ß¤@­È¡v¡A¦Ó«D4#¹Ï¥Üªº¹w´Áµ²ªG¡C

samwang

¦^´_ 8# p212

P¤j½Ð°Ý#4ªºµ²ªG¡A¥¦ªº±ø¥ó¬°©M???

fantersy

¦^´_ 9# samwang


    ·PÁ¨â¦ì¤j¤jªº»¡©ú
¤p§Ì¥ý¨Ó¬ã¨s¤@¤U¤½¦¡¤º®e
·P®¦!!