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

¨D¨C¤ë³Ì¤j»P³Ì¤pNO¤§­pºâ

¨D¨C¤ë³Ì¤j»P³Ì¤pNO¤§­pºâ

°ÝÃD¡G¨D¨C¤ë³Ì¤p»P³Ì¤jNO¡Aº|±¼NO»P­p¼Æ¡H

¨D¨C¤ë³Ì¤j»P³Ì¤pNO¤§­pºâ.zip (55.78 KB)

§Æ±æ¤ä«ù!

H3:I3 {=QUARTILE(IF(($G3=$A$2:$A$2336)*(H$1=MID($D$2:$D$2336,4,2)),--$B$2:$B$2336),{0,4}) }
¿ï¾ÜH3:I3³o2®æ¡A°}¦C¤½¦¡¿é¤J¡A CTRL¡BSHIFT¥ý«ö¤£©ñ¡A¦b«öENTER¿é¤J
¿ï¾ÜH3:I3³o2®æ¤U©Ô

J3 {=IF(I3-H3+1=K3,"",LOOKUP(1,0/(FREQUENCY(IF(($G3=$A$2:$A$2336)*(H$1=MID($D$2:$D$2336,4,2)),--$B$2:$B$2336),ROW(INDIRECT(H3&":"&I3-1)))=0),ROW(INDIRECT(H3&":"&I3)))) }
¥u¯à¨D¥X¯Ê¼Æ³Ì«á¤@­Ó
°}¦C¤½¦¡¿é¤J¡A CTRL¡BSHIFT¥ý«ö¤£©ñ¡A¦b«öENTER¿é¤J
¤U©Ô

K3 {=COUNT(0/FREQUENCY(IF(($G3=$A$2:$A$2336)*(H$1=MID($D$2:$D$2336,4,2)),--$B$2:$B$2336),--$B$2:$B$2336)) }
°}¦C¤½¦¡¿é¤J¡A CTRL¡BSHIFT¥ý«ö¤£©ñ¡A¦b«öENTER¿é¤J
¤U©Ô

¨D¨C¤ë³Ì¤j»P³Ì¤pNO¤§­pºâ_KK.rar (58.94 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

ML089¤j¤j,º|±¼¼Æ,¬O­n¦©±¼,没»¡²M·¡,¦ý¤½¦¡,­Yº|¦b·í¤ë³Ì«á¤@µ§,µLªkÅã¥Ü,¨º¦pªGº|±¼¤Gµ§¥H¤W,¨ç¼Æ¬O§_¨¬¥HÀ³¥I?
§Æ±æ¤ä«ù!

TOP

¥»©«³Ì«á¥Ñ s7659109 ©ó 2018-8-21 07:55 ½s¿è

¼W¥[º|¸¹¦hµ§®É¡AµLªk¿z¿ï¥X¨Ó¡A¥t­Y·í¤ëº|¦b³Ì«á¤@µ§¤]µLªkÅã¥Ü¡A¥t¥~­p¼Æ­n±Nº|¸¹¦©°£

¨D¨C¤ë³Ì¤j»P³Ì¤pNO¤§­pºâ0821 (2).zip (60.03 KB)

§Æ±æ¤ä«ù!

TOP

¦^´_ 4# s7659109


J3 °}¦C¤½¦¡¡A¤U©Ô
=MID(SUBSTITUTE(TEXT(SUM(IFERROR(LARGE((COUNTIFS($A:$A,$G3,$D:$D,LEFT($D3,3)&H$1&"*",$B:$B,ROW(INDIRECT(MAX(1,--H3)&":"&MAX(I3+0,L3-1))))=0) * ROW(INDIRECT(MAX(1,--H3)&":"&MAX(I3+0,L3-1))), ROW($1:$5))*10^{0;3;6;9;12},0)),REPT("¡B!0!0000",5)),"¡B00000",""),2,30)

¤½¦¡°²³] RENO¬O 00nnn ªº3¦ì¼Æ¡A³Ì¤j¥i¥H¨ú5¯Ê¼Æ¡C­Y¬O RENO¬O nnnnn ªº5¦ì¼Æ¡A³Ì¤j¥i¥H¨ú3¯Ê¼Æ¡A»Ý­×§ï¤½¦¡¡C


¨D¨C¤ë³Ì¤j»P³Ì¤pNO¤§­pºâ0821.rar (60.31 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

ML089¤j¤j,º|±¼¼Æ,¬O­n¦©±¼,没»¡²M·¡,¦ý¤½¦¡,­Yº|¦b·í¤ë³Ì«á¤@µ§,µLªkÅã¥Ü,¨º¦pªGº|±¼¤Gµ§¥H¤W,¨ç¼Æ¬O ...
s7659109 µoªí©ó 2018-8-20 20:37


º|¸¹¦ì©ó·í¤ë³Ì¤j»P¤U¤ë³Ì¤p¤§¶¡?               

¸¹½XÀˬd¤è¦¡¡A¥»¤ë³Ì¤p¸¹ ¦Ü MAX(¥»¤ë³Ì¤j¡A¤U¤ë³Ì¤p-1)¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

ML089¤j¤j,ÁÂÁÂ,ok
§Æ±æ¤ä«ù!

TOP

­Y¥Hvba,¸Ó¦p¦ó¼g?
§Æ±æ¤ä«ù!

TOP

¤@¤ë³Ì«á¤@¸¹ 0012
¤G¤ë²Ä¤@¸¹ 0015

¨º0013.0014¦p¦ó§P©w¬Oº|¦b­þ¤@¤ë???
³Ì«á¤@¤ë³Ì«á¤@¸¹0334, ¦p¦ó§P©w«á­±ªº0335~????¬O§_º|¸¹???
¦A«h¦³µL¸ó¦~°ÝÃD???

TOP

°ÝÃD¡G
        1.º|¸¹¥i¯à¦b·í¤ë¤§¶¡¡A¤]¥i¯à¦b¦¸¤ë¤§«e¡A­Y¦b¦¸¤ë¤§«eÂk¦b«e¤ë¡A¥HAAA 1¤ë¬°¨Ò¡A00003¡B00005¦b1¤ë¶¡¡A¦ý00012¦b2¤ëRENO 00013¶}©l¤§«e                                                                               
        2.·s¼W«ö¤é´Á°_°W¸¹½s¦C                                                                               
        µL¸ó¦~«×°ÝÃD¡]¶È1-12¤ë¡^

¨D¨C¤ë³Ì¤j»P³Ì¤pNO¤§­pºâ0822¶i¶¥ª©.zip (70.52 KB)

§Æ±æ¤ä«ù!

TOP

        ÀR«ä¦Û¦b : ¯à·F¤£·F¡A¤£¦p­W·F¹ê·F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD