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

[µo°Ý] ½Ð°Ý¸Ó¦p¦ó±Æ¦W¤Î±Æ§Ç

[µo°Ý] ½Ð°Ý¸Ó¦p¦ó±Æ¦W¤Î±Æ§Ç

¦U¦ì¤j¤j±z¦n
¤p§Ì¦³«Ü«æ¥B«Ü¤jªººÃ°Ý·Q½Ð±Ð¦U¦ì¤j¤j¡A¤½¥q­n°µ¤@­Ó³øªí¡A¸Ô¦pªþ¥ó¡A
¥ªÃä¦ìKEY·~ÁZ¸ê®Æ©Ò¥Î¡A¤¤¶¡¬°¨C¤@³¡ªùªº·~ÁZ±Æ¦W¡A¥kÃ䬰¨C¦ì·~°Èªº±Æ¦W¡A
½Ð±Ð¦U¦ì¤j¤j¡A¤¤¶¡¨C¤@³¡ªùªº·~ÁZ±Æ¦W©M¥kÃ䬰¨C¦ì·~°Èªº±Æ¦W¡A¸Ó¨Ï¥Î­þºØ¨ç¼Æ©Î¤½¦¡¡A
¥u­n¨C¤@¦¸¦b¥ªÃäKEY¤J·~ÁZ¸ê®Æ«á¡A¤¤¶¡©M¥kÃ䪺¦W¦¸¸ê®Æ®æ¸Ì¡A·|¦Û°Ê±Æ¦W¨Ã¥B«ö·Ó
1¡B2¡B3¡B4¨Ì§Ç±Æ¦W¤U¨Ó©O¡H·Ð½Ð¦U¦ì¤j¤j¸Ñ±Ï~ÁÂÁ ^ ^

DEAR  SIR -
  L3Ä橹¤U  KEY IN  1 2 3 4 5 ....
  M3ÄæKEY IN¦p¤U¤½¦¡©¹¤UCOPY¤½¦¡  §Y¥i¦Û¦æ§ì¨ú 1 2 3 4 5 ¤§¶¤¦W.
=INDEX($JJ,MATCH(LARGE($K$2K$17,ROW($A1)),$K$2K$17,0)+1)
ù

TOP

¤½¦¡¿ù»~~¸Ó«ç»ò¿ì?

TOP

¦^´_ 1# mj0917m
­Ó¤H¹ï©ó§ó¤è«Kªº¤è¦¡¨ä¹ê¨S¦³¾Ç¦n,¥u¦n¥Î¤gªk·Ò¿ûªº¤è¦¡,¤@¨B¨B©î¥X§A­nªº¤è¦¡,½Ð§A¦Û¦æ°Ñ¦Ò¬Ý¬Ý
1040620.tar (16 KB)

TOP

ÁÂÁÂmorgan6312 ^ ^

TOP

K2:K10=OFFSET(B$14,INT((ROW(A1)-1)/4)*12,MOD(ROW(A1)-1,4)*2)
L2:L10=RANK(K3,K$3:K$10)
O2:O31=INDIRECT(ADDRESS(MAX((A$3:H$24=N3)*ROW(A$3:H$24)),MAX((A$3:H$24=N3)*COLUMN(A3:H24))+1))
P2:P31=RANK(O3,O$3:O$31)

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD