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

[µo°Ý] ±Æ§Ç°ÝÃD

[µo°Ý] ±Æ§Ç°ÝÃD

­É¥Îgyeonwoo0128¤j¤jªº¨Ò..

½Ð±Ð¦U¦ì¤j¤j.. ¦pªG§Ú·Q§â¥ªÃäÅܦ¨¥kÃ䪺±Æ§Ç.. ½Ð°Ý¤½¦¡¥i¥H°µ¨ì¶Ü?
§Ú¹J¨ìªº°ÝÃD¬O: §Ú¤£½T©w¨C¤@¹ï¤â¦³¦h¤Ö¦¸¦^¦X..
§Ú·Q«ö¹ï¤â¨Ó±Æ§Ç.. ¦]¬°¹ï¤â¥X²{¦¸¼Æ¤£¤@.. §Ú¤£À´±o«ç¼Ë¥i¥H¥Î¤½¦¡¨Ó³B²z..

¥ýÁÂÁ¦U¦ì¤j¤jÀ°¦£..

sample 2.rar (9.9 KB)

{=INDEX(A:A,RIGHT(SMALL((10-MATCH($C$2:$C$41,$C$2:$C$41,))/1%%+$B$2:$B$41/1%+ROW(B$2:B$41),ROW(A1)),2))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522


½Ð°Ý¤@¤U¤j¤j.. §Ú­n¦b¨º­Ó®æ¥´³o­Ó¤½¦¡©O...

TOP

¦^´_ 3# jomeow


    ³£¥i ¤TÁä ¥k©Ô ¤U©Ô
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 4# hcm19522


¦n¼F®`§r... ÁÂÁ§A...

TOP

¦^´_  jomeow


    ³£¥i ¤TÁä ¥k©Ô ¤U©Ô
hcm19522 µoªí©ó 2017-5-25 16:57


§Ú·Q°Ý¤j¤j..
SMALL((10-MATCH($C$2:$C$41,$C$2:$C$41,))/1%%+$B$2:$B$41/1%+ROW(B$2:B$41),ROW(A1))
³o¤@³¡¥÷ÂI¸Ñ©O?  
¬°¦ó­n¥Î%% ©M %??

TOP

¦^´_ 6# jomeow


    "/1%%" -->=*10000 ;"/1%" -->=*100 ¤§·N ;¸g "/"»P"+" ­pºâ¥X¦UÄæ¦ì¼Æ¦r ,§Y¥i±Æ§Ç ;­«ÂI¦b³Ì«áROW(B$2:B$41) ;©Ò¥H¨ú«á­±2¼Æ¦æ¸¹  ,¨ìÄæ¦ì¨ú©Ò»Ý¸ê®Æ
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD