[µo°Ý] ±Æ§Ç¤@°Ý

hin05

·Q½Ð°Ý¨Ò¦p¥H¤U¨Ò¤l¡A¤½¦¡À³¸Ó«ç³]?
    ¤¤¤å  ­^¤å  ¼Æ¾Ç
A  100   80    90
B   90    80    70
C   80    70    80
D   60   100  100
E   90    70    90
¡K¡K¡K¡K
Z   60    70    70

¤¤¤å: A B E C D Z¡K(¥uÅã¥Ü±Æ¦WÀY15­Ó¶µ¥Ø)
­^¤å: D A B C E Z¡K
¼Æ¾Ç: D A E C B Z¡K

¦¹¥~¡A§ÚÁÙ·Q¹Á¸Õ¥t¤@ºØ¼Ò¦¡
¤¤¤å: A B E C D Z¡K(Åã¥Ü¾Ö¦³±Æ¦WÀY15¤À¼Æªº¤H¡A¥X²{¦P¤À±Æ¦W·|¦h©ó15­Ó¡Aª½¨ì±Æ§¹¤À¼Æ±Æ15ªº¤H)
­^¤å: D A B C E Z¡K
¼Æ¾Ç: D A E C B Z¡K

·Q½Ð°Ý¦U¦ì¦b³o2ºØ¼Ò¦¡¤U¤½¦¡¥i¥H«ç¼Ë³]?
·P¿E¤£ºÉ

hin05

¦^´_ 4# hcm19522

·PÁ¡AÁöµMÁÙ¬O¦³ÂI¤£À´

hcm19522

B12:U14{=IFERROR(INDEX($A$1:$AA$1,SMALL(IF(OFFSET($B$1,MAX(ROW(A1)),,,26)>=LARGE(OFFSET($B$1,MAX(ROW(A1)),,,26),15),COLUMN($B2:$AA2)),COLUMN(A1))),"")

hin05

¦^´_ 2# hcm19522


   

¤U¸ü (65.12 KB)

2015-12-13 19:27

¡D·Q¦A½Ð±Ð¤@¤U,¦pªG±N¼Æ¾Ú­Ë¸m,¤½¦¡B12:U14ªº¤½¦¡¬O¤£¬O¥i¥H§ï¦¨{=IFERROR(INDEX($A1:$AA1,SMALL(IF(OFFSET($B$1,,MAX(COLUMN(A1)),26)>=LARGE(OFFSET($B$1,,MAX(COLUMN(A1)),26),15),COLUMN(B2:AA2)),ROW(A1))),"")}?
¡@
¡DÁÙ¦³¦pªG­n¨ú±Æ³Ì«áªº10­Ó¶µ¥Ø¥i¥H±q§ï³o¤½¦¡±o¥X¶Ü? ¥H¤Î³o­Ó¤½¦¡¥i¥H¦A¥[¤W¤À¼Æªº±Æ§Ç¦Ó¤£¬O®Ú¾Ú­^¤å¶¶§Ç¶Ü,´N¬O¤À¼Æ³Ì°ªªº©m¦W±Æ³Ì«e­±,¦p¦¹Ãþ±À?·PÁÂ!

hcm19522

http://blog.xuite.net/hcm19522/twblog/364874996