When I rank these data in descending order, results are as follows,
Value Rank
100.00% 9
100.00% 9
200.00% 14
0.00% 5
-100.00% 1
0.00% 5
-100.00% 1
100.00% 9
0.00% 5
-100.00% 1
200.00% 14
100.00% 9
100.00% 9
0.00% 5
-100.00% 1
There are 15 numbers but highest rank shows as 14.
Please help me I'm using Excel 2007.
Bookmarks