Excel RANK Function
Returns the rank of a number in a list of numbers
=RANK (number, ref, [order])
Obtained Marks Rank Formula
56 6 =RANK(B8,$B$8:$B$14)
66 4 =RANK(B9,$B$8:$B$14)
78 3 =RANK(B10,$B$8:$B$14)
65 5 =RANK(B11,$B$8:$B$14)
89 1 =RANK(B12,$B$8:$B$14)
45 7 =RANK(B13,$B$8:$B$14)
87 2 =RANK(B14,$B$8:$B$14)
nction
rs
Explanation
Rank 6 in the list of marks
Rank 4 in the list of marks
Rank 3 in the list of marks
Rank 5 in the list of marks
Rank 1 in the list of marks
Rank 7 in the list of marks
Rank 2 in the list of marks
Using RANK Function
Name Obtained Marks
James 56
Olivia 66
Michael 78
Bernard 65
Tylor 89
Miller 45
Wilson 87
Thomas 81
Scott 74
Harris 88
Turner 34
Using RANK Function in Descending Order
Name Obtained Marks Rank
James 56 9
Olivia 66 7
Michael 78 5
Bernard 65 8
Tylor 89 1
Miller 45 10
Wilson 87 3
Thomas 81 4
Scott 74 6
Harris 88 2
Turner 34 11
Try Yourself
Name Obtained Marks
James 56
Olivia 66
Michael 78
Bernard 65
Tylor 89
Miller 45
Wilson 87
Thomas 81
Scott 74
Harris 88
Turner 34
y Yourself
Rank
Applying RANK Function in Ascending Order
Name Obtained Marks Rank
James 56 4
Olivia 66 5
Michael 78 7
Bernard 55 3
Tylor 89 11
Miller 45 2
Wilson 87 9
Thomas 81 8
Scott 74 6
Harris 88 10
Turner 34 1
Try Yourself
Name
James
Olivia
Michael
Bernard
Tylor
Miller
Wilson
Thomas
Scott
Harris
Turner
Try Yourself
Obtained Marks Rank
56
66
78
65
89
45
87
81
74
88
34
Employing RANK Function in Non-Contiguous Cells
Name Obtained Marks Rank
James 56 5
Olivia 66 4
Michael
Bernard
Tylor 89 1
Miller 45 6
Wilson 87 2
Thomas 81 3
Scott
Harris
Turner
Try Yourself
Name Obtained Marks
James 56
Olivia 66
Michael
Bernard
Tylor 89
Miller 45
Wilson 87
Thomas 81
Scott
Harris
Turner
rself
Rank
Using RANK Function to Get Unique Value
Name Obtained Marks Rank
James 56 8
Olivia 66 6
Michael 56 8
Bernard 65 7
Tylor 89 1
Miller 45 10
Wilson 87 3
Thomas 81 4
Scott 74 5
Harris 88 2
Turner 34 11
Try Yourself
Name
James
Olivia
Michael
Bernard
Tylor
Miller
Wilson
Thomas
Scott
Harris
Turner
Try Yourself
Obtained Marks Rank
56
66
56
65
89
45
87
81
74
88
34
Using RANK Function to Get Unique Value
Name Obtained Marks Rank
James 56 8
Olivia 66 6
Michael 56 9
Bernard 65 7
Tylor 89 1
Miller 45 10
Wilson 87 3
Thomas 81 4
Scott 74 5
Harris 88 2
Turner 34 11
Try Yourself
Name Obtained Marks
James 56
Olivia 66
Michael 56
Bernard 65
Tylor 89
Miller 45
Wilson 87
Thomas 81
Scott 74
Harris 88
Turner 34
rself
Rank
Utilizing RANK Function To Break Ties
Name Obtained Marks Attendance Rank Tie Break
James 56 80% 8 0.05
Olivia 66 75% 6 0
Michael 56 86% 8 0.07
Bernard 65 90% 7 0
Tylor 89 66% 1 0
Miller 45 78% 10 0
Wilson 87 83% 3 0
Thomas 81 94% 4 0
Scott 74 45% 5 0
Harris 88 88% 2 0
Turner 34 90% 11 0
s
Final Rank Name
8.05 James
6 Olivia
8.07 Michael
7 Bernard
1 Tylor
10 Miller
3 Wilson
4 Thomas
5 Scott
2 Harris
11 Turner
Try Yourself
Obtained Marks Attendance Rank Tie Break Final Rank
56 80% 8
66 75% 6
56 86% 8
65 90% 7
89 66% 1
45 78% 10
87 83% 3
81 94% 4
74 45% 5
88 88% 2
34 90% 11
Use of RANK Function Ignoring Zeros
Month Profit Rank
January $560 2
February $400 6
March $0
April $650 1
May -$100 9
June $0
July $500 4
August -$50 8
September $0
October $480 5
November $520 3
December -$10 7
Try Yourself
Month Profit
January $560
February $400
March $0
April $650
May -$100
June $0
July $500
August -$50
September $0
October $480
November $520
December -$10
ourself
Rank
