[½Ð±Ð] ¦p¦ó¨Ï¥Î¤½¦¡¡A ¨Ì¾ÚEÄæ¬Û¦Pªº­È¡A¿z¥XCÄ椣­«½Æªº­È

ABK

¤U¸ü (137.71 KB)

2018-3-15 03:15

¨Ì¾ÚEÄæ¬Û¦Pªº­È¡A¿z¥XCÄ椣­«½Æªº­È.rar (8.04 KB)

¤U¸ü¦¸¼Æ: 10

2018-3-15 03:15

hcm19522

http://blog.xuite.net/hcm19522/twblog/570896803

ABK

·PÁÂhcm¤j !

¦A½Ð±Ð¤@¤U! ¦pªG§Ú­n¦b³Ì¤W­±´¡¤J¨â¦CªÅ¥Õ¡A ¤]´N¬O¾ã­Ó¸ê®Æªí©¹¤U²¾°Ê¨â¦C¡A¥H¤Î¾ã­ÓCÄ檺¸ê®Æ²¾¨ìDÄæ¥h¡A ¤½¦¡­n¦p¦ó§ï? °}¦C¤½¦¡¨S¦³§Ú·Qªº¨º»ò²³æ¡A§ï¤F1­Ó¤p®É§ï¤£¥X¨Ó¡A¥u¦n¨Ó½Ð±Ð!

ABK

¦A½Ð±Ð¤@¤U«e½ú¥ý¹F­Ì!  
¦pªG­n°µªþ¹Ïªº¤ÀÃþ¡A °}¦C¤½¦¡­n¦p¦ó°µ?

naruto018

¦^´_ 4# ABK


   

¤U¸ü (20.34 KB)

2018-3-30 14:09

H2¶ñ¤J¡A¨ä¥L©¹¥k©Î¤U©Ô

1. =IF(SMALL(IF($E$2:$E$35=H$1,IF($C$2:$C$35>MAX(H$1:H1),$C$2:$C$35,4^8),4^8),1)=4^8,"",SMALL(IF($E$2:$E$35=H$1,IF($C$2:$C$35>MAX(H$1:H1),$C$2:$C$35,4^8),4^8),1))

½Æ»s¥N½X

°O±oÂন°}¦C

ABK

¤Ó·PÁ naruto¤j ¤F!    ¥i¥H¥Î¤F!  ÁÂÁ±z ! ·PÁÂ!  ·PÁÂ!

ABK

¥i¥H¦A½Ð±Ðnaruto ¤j¶Ü?   
4^8 ¬O¤°»ò·N²[ »P§@¥Î?

zz5151353

H2 ¤U©ì¤Î¥k©ì
{=IFERROR(INDEX($C:$C,RIGHT(SMALL(IF(($E$2:$E$35=H$1)*N(MATCH($C$2:$C$35&$E$2:$E$35,$C$2:$C$35&$E$2:$E$35,)=ROW($1:$34)),$C$2:$C$35*100+ROW($2:$35)),ROW(1:1)),3),),"")}

4^8  = 65536