[½Ð±Ð] ¦p¦ó¨Ï¥Î¤½¦¡¡A ¨Ì¾ÚEÄæ¬Û¦PªºÈ¡A¿z¥XCÄ椣«½ÆªºÈ
- ©«¤l
- 115
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 178
- ÂI¦W
- 1
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- Office2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-1-12
- ³Ì«áµn¿ý
- 2024-4-26
|
[½Ð±Ð] ¦p¦ó¨Ï¥Î¤½¦¡¡A ¨Ì¾ÚEÄæ¬Û¦PªºÈ¡A¿z¥XCÄ椣«½ÆªºÈ
|
|
|
|
|
|
- ©«¤l
- 1387
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1397
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-11-14
|
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|
- ©«¤l
- 115
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 178
- ÂI¦W
- 1
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- Office2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-1-12
- ³Ì«áµn¿ý
- 2024-4-26
|
·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¨Ó½Ð±Ð! |
|
|
|
|
|
|
- ©«¤l
- 115
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 178
- ÂI¦W
- 1
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- Office2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-1-12
- ³Ì«áµn¿ý
- 2024-4-26
|
¥»©«³Ì«á¥Ñ ABK ©ó 2018-3-29 20:37 ½s¿è
¦A½Ð±Ð¤@¤U«e½ú¥ý¹FÌ!
¦pªGn°µªþ¹Ïªº¤ÀÃþ¡A °}¦C¤½¦¡n¦p¦ó°µ? |
|
|
|
|
|
|
- ©«¤l
- 91
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 130
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-5-14
- ³Ì«áµn¿ý
- 2020-5-17
|
¦^´_ 4# ABK
H2¶ñ¤J¡A¨ä¥L©¹¥k©Î¤U©Ô- =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 |
|
|
|
|
|
|
- ©«¤l
- 115
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 178
- ÂI¦W
- 1
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- Office2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-1-12
- ³Ì«áµn¿ý
- 2024-4-26
|
¤Ó·PÁ naruto¤j ¤F! ¥i¥H¥Î¤F! ÁÂÁ±z ! ·PÁÂ! ·PÁÂ! |
|
|
|
|
|
|
- ©«¤l
- 115
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 178
- ÂI¦W
- 1
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- Office2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-1-12
- ³Ì«áµn¿ý
- 2024-4-26
|
¥i¥H¦A½Ð±Ðnaruto ¤j¶Ü?
4^8 ¬O¤°»ò·N²[ »P§@¥Î? |
|
|
|
|
|
|
- ©«¤l
- 206
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 218
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- OFFICE 365
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW¥x¥_
- µù¥U®É¶¡
- 2010-5-15
- ³Ì«áµn¿ý
- 2023-6-18
|
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 |
|
|
|
|
|
|