EXCEL ¨ç¼Æ ¿ï¥X«e11¦W¸ê®Æ µL¸Ñ
- ©«¤l
- 34
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 42
- ÂI¦W
- 0
- §@·~¨t²Î
- vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-6-9
- ³Ì«áµn¿ý
- 2015-1-6
|
EXCEL ¨ç¼Æ ¿ï¥X«e11¦W¸ê®Æ µL¸Ñ
¥Ø¼Ð:±N¥ª°¼1-20¦W¸ê®Æ¿ï¥X«e11¦W ©ó¥kªí¦C¥X
§Úªº¼gªk¦p¤U
1.DÄæ¥ý¶]¥X¦W¦¸'
=RANK(C2,$C$2:$C$21)
2.HÄæ¿ï¥X1-11¦W¦¨ÁZ(¤À¼Æ1)
'=LARGE(¤À¼Æ,F2)
3.GÄæ(¦WºÙ)¨Ìµ{¦¡¦¸§ÇÅçºâµ²ªG
¥\2.¥\3.¥\4¤½¦¡¨ÃÅçºâ(F9)µ²ªG(¦p¹Ïªí³£OK)¿é¤J§¹¦¨«ö Ctrl+Shift+Enter Áä
°ÝÃD¬O:=VLOOKUPªº¨BÆJ,¥X²{°ÝÃD#REF #N/A... ,´N¬OµLªkÅã¥Ü§Únªº¦WºÙ
½Ð°Ý'=VLOOKUP(SMALL(IF(H2=¤À¼Æ,½s¸¹,FALSE),COUNTIF($H$2:H2,H2)),¸ê®Æ,2)¨º¸Ì¥X°ÝÃD ÁÂÁÂ! |
|
|
|
|
|
|
- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2014-8-25 22:26 ½s¿è
¦^´_ 1# abba9817
¨Ì1#¹Ï¨Ò¸Ñ
1¡BDÄæ¡u¦W¦¸¡v«Øij§ï©R¦W¬°¡u»²§U¡v¡AÀx¦s®æD2¿é¤J
=C2+(1000-ROW())/10000
¦V¤U½Æ»s¤½¦¡
2¡B¿ï¨úB1:D21½d³ò¡A«öCtrl+Shift+F3¡A¥H¡u³»ºÝ¦C¡v¬°¦WºÙ¶i¦æ¡u©w¸q¦WºÙ¡v¡C
3¡BFÄæºû«ù1#¹Ï¨Ò°t¸m
4¡BÀx¦s®æG2¿é¤J¤@¯ë¤½¦¡=INDEX(¦WºÙ,MATCH(LARGE(»²§U,F2),»²§U,0))
Àx¦s®æH2¿é¤J¤@¯ë¤½¦¡=INDEX(¤À¼Æ,MATCH(LARGE(»²§U,F2),»²§U,0))
¦V¤U½Æ»s¤½¦¡
½Ð°Ñ¦Ò¡I |
|
|
|
|
|
|
- ©«¤l
- 34
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 42
- ÂI¦W
- 0
- §@·~¨t²Î
- vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-6-9
- ³Ì«áµn¿ý
- 2015-1-6
|
¦^´_ 2# p212
¤µ¦¬Ý¨ì¦^«H.¤Ó·PÁ¤F.§Ú·|§Q¥ÎªÅÀɮɴú¸Õקï.µ²ªG.¦A§iª¾.¦A»¡Án·PÁ |
|
|
|
|
|
|
- ©«¤l
- 334
- ¥DÃD
- 139
- ºëµØ
- 0
- ¿n¤À
- 621
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWSXP
- ³nÅ骩¥»
- OFFICE2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥x¥_¿¤
- µù¥U®É¶¡
- 2010-8-5
- ³Ì«áµn¿ý
- 2022-11-3
|
¦^´_ 2# p212
½Ð°Ý¬°¦óD2n¿é¤J¦¹¤½¦¡©O?
D2=C2+(1000-ROW())/10000
ÁÂÁÂ |
|
joyce
|
|
|
|
|
- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2014-8-26 13:06 ½s¿è
¦^´_ 4# leiru
³B²z¦P¤ÀªÌ¬Û¦P±Æ¦W°ÝÃD
±N즳¨Ó·½¸ê®Æªº¡u¤À¼Æ¡v¥[¤W(1000-ROW())/10000©Ò²£¥Íªº¤£«½Æ¤p¼Æ(¦C¸¹·U¤j¡A¥[¤Wªº¼Æ¦r·U¤p)¡A¥H»s³y¥X¡u»²§U¡vÄæ¦ì·sªº¤£«½Æªº¡u¤À¼Æ¡v¡C
½Ð°Ñ¦Ò¡I |
|
|
|
|
|
|
- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 277
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-12-23
|
¦^´_ 1# abba9817
©w¸q¦WºÙ
Rng
=OFFSET(¤u§@ªí1!$C$2,,,COUNT(¤u§@ªí1!$C:$C),)
H2:K21°}¦C¤½¦¡
=INDEX($A$2:$D$21,MATCH(SMALL(RANK(Rng,Rng)+COUNTIF(OFFSET(Rng,-1,,ROW(INDIRECT("A1:A"&COUNT(Rng)))),Rng),ROW(INDIRECT("A1:A"&COUNT(Rng)))),RANK(Rng,Rng)+COUNTIF(OFFSET(Rng,-1,,ROW(INDIRECT("A1:A"&COUNT(Rng)))),Rng),0),{1,2,3,4})
Rank.zip (9.31 KB)
|
|
¾Ç®üµL²P_¤£®¢¤U°Ý
|
|
|
|
|