??????? ????????? ?? excel: ???? ???????? ???????? ??????

?????? ????????? ?????? ?????????
???? ???????: 828678 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

?????? ??? ??????? ????? ??????? ????? ????? ???? ????? ????????? ????????.

??????? ????

??? ????? ???????? ??????? ??? ????? ?? ????? ?????? ???????? ??? ????? ????????? ???????? ?? ???? ????? ??? ???? ????????? ??? ????? ?? ?????? ???????? ???. ?????? ??????? ?? ??? ??????? ???? ???.

??? ????? ?? ?? ??????? ?????? ?? ?????? ?????? ????? ?????? ????? ???????? ?????? ??? ??????? ?????? ??? ???? ?????. ??? ???? ??????? ?? ????? ??? ????? ??????? ties ??? ??? ?????? ?????? ????? ??????? ??? ????? ????? ????.

??? ??? ??????? ???? ???? ??? ??????? ???? ?? ??? "??????? ??????" ? Microsoft Office Excel 2003 ?????????? ??????? ?? Excel (???? ?? ????? "??????? ??????" ???????). ???? ??? ??????? ???? ????? ????? ??????? Excel ????. ?? ??? ????? ?????? ???? ?????.

???? ??????

RANK(number, ref, order)
?????? ??? ??? ?? ???? ???? ?????; ref ??? ?? ???? ?????? ?? ???? ??????? ???? ????? ??? ??? ???????? ???????; ??? ????????. ??? ??? ???? ???? ?? ????? ???? 0 (???)? ?????? ??? ???? ??? ?? ref if ref ??? ????? ????? ?? ????? ??????. If ??? ??? ????? ??? ???? ??? ?????? ref ????? ?? ???? ????? ?? ????? ??????.

???? ??? ?????????

?????? ??? ????????? ??????? ????? ???? ??? Excel ?????? ??? ?????? ??????, ??? ?????? A1 ?? ???? ??? Excel ????? ????? ??? ?? ???? ??? ??? ??? ????? ??????? ??? ?? ????????? ???????? ?? ?????? ?????? ????? ??????? ????????? ?? ???? ????? ?????? ??.

?????? ?? Microsoft Office Excel 2007? ??? ??? ??? ??????? ???????? ??? ?????? ???????? ?? ????? ???????.
?? ??? ??????????? ??? ??????
10=RANK(A1,$A$1:$A$12,1)= B1 + (COUNT($A$1:$A$12) + RANK($A1,$A$1:$A$12,1)-RANK($A1,$A$1:$A$12,0)-1)/2=RANK(A1,$A$1:$A$12,0)= E1 + (COUNT($A$1:$A$12) + RANK($A1,$A$1:$A$12,1)-RANK($A1,$A$1:$A$12,0)-1)/2
21=RANK(A2,$A$1:$A$12,1)= B2 + (COUNT($A$1:$A$12) + RANK($A2,$A$1:$A$12,1)-RANK($A2,$A$1:$A$12,0)-1)/2=RANK(A2,$A$1:$A$12,0)= E2 + (COUNT($A$1:$A$12) + RANK($A2,$A$1:$A$12,1)-RANK($A2,$A$1:$A$12,0)-1)/2
21=RANK(A3,$A$1:$A$12,1)= B3 + (COUNT($A$1:$A$12) + RANK($A3,$A$1:$A$12,1)-RANK($A3,$A$1:$A$12,0)-1)/2=RANK(A3,$A$1:$A$12,0)= E3 + (COUNT($A$1:$A$12) + RANK($A3,$A$1:$A$12,1)-RANK($A3,$A$1:$A$12,0)-1)/2
21=RANK(A4,$A$1:$A$12,1)= B4 + (COUNT($A$1:$A$12) + RANK($A4,$A$1:$A$12,1)-RANK($A4,$A$1:$A$12,0)-1)/2=RANK(A4,$A$1:$A$12,0)= E4 + (COUNT($A$1:$A$12) + RANK($A4,$A$1:$A$12,1)-RANK($A4,$A$1:$A$12,0)-1)/2
21=RANK(A5,$A$1:$A$12,1)= B5 + (COUNT($A$1:$A$12) + RANK($A5,$A$1:$A$12,1)-RANK($A5,$A$1:$A$12,0)-1)/2=RANK(A5,$A$1:$A$12,0)= E5 + (COUNT($A$1:$A$12) + RANK($A5,$A$1:$A$12,1)-RANK($A5,$A$1:$A$12,0)-1)/2
33=RANK(A6,$A$1:$A$12,1)= ? 6 + (COUNT($A$1:$A$12) + RANK($A6,$A$1:$A$12,1)-RANK($A6,$A$1:$A$12,0)-1)/2=RANK(A6,$A$1:$A$12,0)= E6 + (COUNT($A$1:$A$12) + RANK($A6,$A$1:$A$12,1)-RANK($A6,$A$1:$A$12,0)-1)/2
33=RANK(A7,$A$1:$A$12,1)= B7 + (COUNT($A$1:$A$12) + RANK($A7,$A$1:$A$12,1)-RANK($A7,$A$1:$A$12,0)-1)/2=RANK(A7,$A$1:$A$12,0)= E7 + (COUNT($A$1:$A$12) + RANK($A7,$A$1:$A$12,1)-RANK($A7,$A$1:$A$12,0)-1)/2
52=RANK(A8,$A$1:$A$12,1)= ? 8 + (COUNT($A$1:$A$12) + RANK($A8,$A$1:$A$12,1)-RANK($A8,$A$1:$A$12,0)-1)/2=RANK(A8,$A$1:$A$12,0)= E8 + (COUNT($A$1:$A$12) + RANK($A8,$A$1:$A$12,1)-RANK($A8,$A$1:$A$12,0)-1)/2
52=RANK(A9,$A$1:$A$12,1)= ? 9 + (COUNT($A$1:$A$12) + RANK($A9,$A$1:$A$12,1)-RANK($A9,$A$1:$A$12,0)-1)/2=RANK(A9,$A$1:$A$12,0)= E9 + (COUNT($A$1:$A$12) + RANK($A9,$A$1:$A$12,1)-RANK($A9,$A$1:$A$12,0)-1)/2
52=RANK(A10,$A$1:$A$12,1)= + B10 (COUNT($A$1:$A$12) + RANK($A10,$A$1:$A$12,1)-RANK($A10,$A$1:$A$12,0)-1)/2=RANK(A10,$A$1:$A$12,0)= E10 + (COUNT($A$1:$A$12) + RANK($A10,$A$1:$A$12,1)-RANK($A10,$A$1:$A$12,0)-1)/2
61=RANK(A11,$A$1:$A$12,1)= B11 + (COUNT($A$1:$A$12) + RANK($A11,$A$1:$A$12,1)-RANK($A11,$A$1:$A$12,0)-1)/2=RANK(A11,$A$1:$A$12,0)= E11 + (COUNT($A$1:$A$12) + RANK($A11,$A$1:$A$12,1)-RANK($A11,$A$1:$A$12,0)-1)/2
73=RANK(A12,$A$1:$A$12,1)= ? 12 + (COUNT($A$1:$A$12) + RANK($A12,$A$1:$A$12,1)-RANK($A12,$A$1:$A$12,0)-1)/2=RANK(A12,$A$1:$A$12,0)= E12 + (COUNT($A$1:$A$12) + RANK($A12,$A$1:$A$12,1)-RANK($A12,$A$1:$A$12,0)-1)/2
?????? ??? ??? ??? ?????? ?? ???? ??? Excel ?????, ???? ??? ?????? ????? ????? ??? ?? ???? ??? ?????? ????? ??????.

?? Excel 2003? ?? ?????? ???? ?? ????? ??? ??? ???? ??? ????? ???????? ??? ?? ???? ??? ?????? ?????? ???????.

?? Excel 2007? ?? ?????? ?????? ?????? ?????, ???? ??? ????? ?? ?????? ???????? ??? ?????? ???????? ????? ???????? ??? ?? ???? ??? ??? ?????? ???????? ????????.

???? ???????? ?? ????? ??? ??????? ????? ????? ?? ????? ?? ????????. ?????? ????? ????? ???? ??????? ?????? ??? ?????? ???? ???? ?????? ??????. ???? ???? ??????? ??? ???????? ??? ??? ???? ???? ??????? ?? (????? ????????? = 0 ?? ????) ?? (????? ????????? = ???? ??? ?????).
(COUNT(ref) + 1 ? RANK(number, ref, 0) ? RANK(number, ref, 1))/2.
???? ????? ???? ??? ??????? ??????. ???? ???????? ?? ??????? A1:A12. ???? ????? RANK ????? ?????? ?????? ?? ??????? B1:B12. ????? ????????? ?? ??????? a2: a5 ????? 21 ?????. ??? ???? ????? 2 ?????. ???? ??? ??????? ?????? ?????? ?????? 10. ??? ????? ??????? ?? 21 ??? ????? ??????? 2? 3 ? 4 ? 5 ???? ????? ????? (2 + 3 + 4 + 5)/4 = 3.5. ????? ?????? ????????? ????? ?? ??????? A6:A7 ?? 33? ???? ???? ????????? ?? ????? ???. ????? ??? ????????? ????? ??? ????? ??????? 6 ? 7 ???? ???? ????? (6 + 7)/2 = 6.5. ???????? ???? ??????? ?? A8:A10 ????? ????? ??? ???? ?????? 52. ???? ???? ????????? ?? ????? ???. ????? ??? ????????? ????? ??? ????? ??????? 8 ? 9 ? 10 ???? ???? ????? (8 + 9 + 10)/3 = 9.

??????? ???? C ????? ??? ???? ??????? ?? ??? ????? ????? ?????? ??? ?????? ??????? ???? ????? ???????. ????? ?? ???????? B ? C ?? ????? ????? ??? ????????? ?? ????? ???????? ????? ??? ???? 1 ? 11 ? 12.

E1:E12 ????? ????? ??? ???? RANK ????? ?????? ??????. ???? ??????? ?? ???? ??? ?? ????? ??????? ?? ??????? A8:A10. A8:A10 ????? ????? ??? ???? ?????? 54. ????? ??? ????? ??????? ??? ????? ??????? 3 ? 4 ? 5 ???? ????? ????? (3 + 4 + 5)/3 = 4. ???? ???? ??????? ?? ????? ??? ??? ????????? ?? ??????? A6:A7. A6:A7 ????? ????? ??? ???? ?????? 33. ????? ??? ??????? ??? ????? ??????? 6 ? 7 ???? ???? ????? (6 + 7)/2 = 6.5. ???? ???? ??????? ????? ??? ???? ??? ?? ????? ??????? ?? ??????? a2: a5. ????? ??????? a2: a5 ???? ??????? 21. ????? ??? ????? ??????? ??? ????? ??????? 8, 9 ? 10 ? 11 ?????? ??? ???? ????? (8 + 9 + 10 + 11)/4 = 9.5.

????????? ?? ???? F ????? ??? ???? ??????? ?? ??? ????? ????? ?????? ??? ?????? ??????? ???? ????? ???????. ????? ???????? ?? ??????? E ? F ?? ????? ????? ??? ????????? ?? ????? ???????? ????? ??? ???? 1 ? 11 ? 12.

???????

???? ??? ??????? ????? ???? ????? ???? ????? ????????? ????? ????? ???? ????? ??? ?????? ????????. ????? ??????? ???? ??????? ???? ??? ??? ?? ?????? ?????. ???? ??????? ???? ???? ???? ??? ????? ???? ???? ?? ????? ?????? ?? ??????.

???????

???? ???????: 828678 - ????? ??? ??????: 09/????? ??????/1434 - ??????: 4.0
????? ???
  • Microsoft Office Excel 2007
????? ??????: 
kbexpertisebeginner kbinfo kbmt KB828678 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????828678

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com