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

±Æ¦W°ÝÃD

±Æ¦W°ÝÃD

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

±Æ¦W.png
2019-3-7 16:54


±Æ¦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ªº¼Æ­È
RIGHT.png
2019-3-8 15:47

ÁÙ¦³¤@¨Æ·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 : ¯à·F¤£·F¡A¤£¦p­W·F¹ê·F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD