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

±Æ¦W°ÝÃD

±Æ¦W°ÝÃD

½Ð±Ð«e½ú­Ì ¦p¦ó¦bH2:H21 ¸Ì­±Åã¥Ü¥X 100­Ó¿ï¤â ¤À¼Æ«e20¦Wªº»â¨ú¦W³æ ¦W³æ¤£­«½Æ ¥²¶·¥]§t D1ªº¯}®æ¦W³æ



±Æ¦W1.rar (10.09 KB)

¯}®æ~~«ü[Àu¥ý]¨ú???
H2/°}¦C¤½¦¡:
=INDEX(A:A,RIGHT(LARGE((COUNTIF(D:D,A$2:A$101)*100+B$2:B$101)/1%%+ROW($2:$101),ROW(A1)),4))

TOP

¦^´_ 2# ­ã´£³¡ªL
ÁÂÁ­ã¤j  
·Q½Ð±Ð­ã¤j ¹Ï¤ù°é°_¨Ó ³o­Ó Right ¤½¦¡ ªº«á­±³o­Ó¼Æ­È¬O·|¼vÅT­þ­Ó³¡¤À
¦]¬°§Úµo²{ ¦b§Ú¹ïÀ³ªº¸ê®Æ ­n¿é¤J2 ¤~·|¬O¥¿½Tªº¼Æ­È

ÁÙ¦³¤@¨Æ·Q½Ð±Ð­ã¤j  Àɮצ³°}¦C¸ê®Æ ¥u­n¶}±Ò ´Nºâ³£¤£­×§ï ¤]·|¥X²{ Àɮפw³Q­×§ï¹L
³o³¡¤À ¦³¤èªk¥i¥H¸Ñ¨M±¼¶Ü? ¦]¬°§Ú¬O¥Î®×¥óºëÆF¥h¥´¶}³o­ÓexcelªºÀÉ®× ¦p¦³³o°ÝÃD³Ì«á³£·|¦h¶]¥X ¥t¦s·sÄÒªºµøµ¡¥X¨Ó
¬O§_¦³¤ñ¸û¦X¾Aªº¤èªk¸Ñ¨M ¤ñ¦p ¥´¶}³o­ÓÀÉ®×´N¦Û°Ê¦sÀɪºµ{¦¡

TOP

H2¤@¯ë¤½¦¡¡Aª`·N¤½¦¡¤@©w­n©ñH2¡A©ñ§Oªº¦a¤è­n­×§ï¬õ¦â¦ì¸m
=LOOKUP(,0/FREQUENCY(-200,-(COUNTIF(H$1:H1,A$2:A$101)=0)*(B$2:B$101+COUNTIF(D:D,A$2:A$101)*100)),A$2:A$101)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# eric7765


¤À¼Æ´X¦ì¼Æ?? ¤p¼Æ´X¦ì??
¤£À´®×¥óºëÆF¬O¦ó???

TOP

¦^´_ 5# ­ã´£³¡ªL
­ã¤j ©êºp §Ú»~·|¤F¤@¨ÇªF¦è ³o­Ó°}¦C¤½¦¡ ¤w¸g¸Ñ¨M°ÝÃD ·PÁ§A

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD