Spreadsheet: 778133d1650886283-ranking-with-duplicates-excel_forum_duplicate_ranking
Sheet: Sheet1

 |  |  |  | Getting wrong output in columns "E" and "G"
 |  | -10.2
 |  | -7.450000000000001
 |  | -8.85
 |  | 4.75
 |  | 5.55
 |  | -0.5999999999999996
 |  | -3.699999999999999
 |  | -1.800000000000001
 |  | 0.5999999999999996
 |  | 0
 |  | -11.15
 |  | -3.199999999999999
 |  | 11.3
 |  | 1.6
 |  | 0.6499999999999995
 |  | -9.05
 |  | -11.4
 |  | 5.7
 |  | -4.399999999999999
 |  | 1.700000000000001
 |  | -6.500000000000001
 |  | -9.4
 |  | -4.150000000000002
 |  | -10.15
 |  | -0.9500000000000011
 |  | -2.500000000000002
 |  | -11.35
 |  | -3.85
 |  | -1.550000000000001
 |  | 16.8
 |  | -7.150000000000001
 |  | -13.55
 |  | -23.1
 |  | -8.45
 |  | -5.399999999999999
 |  | -3.05
 |  | -2
 |  | -1.350000000000001
 |  | -5.7
 |  | 2.2
 |  | -15.75
 |  | -2.1
 |  | -11.05
 |  | -15
 |  | 5
 |  | 6.600000000000001
 |  | -1.4
 |  | 3.300000000000001
 |  | -7.300000000000001
 |  | 5.4
 |  | -1.499999999999999
 |  | 0.4500000000000002
 |  | -4.000000000000001
 |  | -8.350000000000001
 |  | -7.85
 |  | -4.65
 |  | -7.200000000000001
 |  | -7.050000000000001
 |  | -9.15
 |  | 3.1
 |  | 3.4
 |  | -4.250000000000001
 |  | -22.3
 |  | 0
 |  | -3.199999999999998
 |  | -2.9
 |  | 3.9
 |  | -20.85
 |  | -7.85
 |  | -7
 |  | -2.300000000000002
 |  | -16.7
 |  | -0.5500000000000007
 |  | 0.3500000000000005
 |  | -8.599999999999998
 |  | -11.15
 |  | -10.1
 |  | -8.6
 |  | 3.800000000000002
 |  | -0.7999999999999994
 |  | -3.799999999999999
 |  | -11.85
 |  | 2.499999999999998
 |  | -9.350000000000001
 |  | 1.450000000000001
 |  | -7.25
 |  | -4.1
 |  | -9.149999999999999
 |  | -12.55
 |  | -9.9
 |  | -9.4
 |  | -3.399999999999999
 |  | -4.5
 |  | -5.5
 |  | -3.350000000000001
 |  | -16.7
 |  | -10.9
 |  | 0
 |  | -6.55
 |  | -6.699999999999999
 |  | -0.6500000000000021
 |  | -0.8000000000000007
 |  | -4
 |  | -7.65
 |  | -4.549999999999999
 |  | -7.9
 |  | -9.6
 |  | -7.350000000000001
 |  | 4.4
 |  | 2.25
 |  | -11
 |  | -10.1
 |  | 3.899999999999999
 |  | -5.900000000000001
 |  | -9
 |  | -16.95
 |  | 4.4
 |  | -1.349999999999999
 |  | -5.5
 |  | -7.300000000000001
 |  | 8.100000000000001
 |  | -6.550000000000001
 |  | -3.9
 |  | 0.4000000000000004
 |  | -0.2000000000000011
 |  | 0.9499999999999993
 |  | 1.800000000000002
 |  | 2.300000000000001
 |  | 20.45
 |  | -11.9
 |  | -12.55
 |  | -19.5
 |  | -5.299999999999999
 |  | -6.050000000000001
 |  | 1.499999999999998
 |  | -4.699999999999999
 |  | -2.500000000000002
 |  | -4.1
 |  | -0.6000000000000005
 |  | -12.45
 |  | 2.450000000000001
 |  | 3.849999999999998
 |  | 2
 |  | -0.7000000000000006
 |  | -11.7
 |  | -0.3500000000000005
 |  | -4.300000000000001
 |  | -9.5
 |  | -16.5
 |  | 5.549999999999999
 |  | -18.05
 |  | -5.700000000000001
 |  | -17.8
 |  | -3.050000000000001
 |  | -14.8
 |  | -10.4
 |  | -10.05
 |  | 5.300000000000001
 |  | -12.35
 |  | -4.6
 |  | -8.799999999999999
 |  | -16.45
 |  | -17.45
 |  | -17.25
 |  | 10.25
 |  | 1.3
 |  | -16
 |  | -3.4
 |  | -5.399999999999998
 |  | 0.6000000000000014
 |  | -13.75
 |  | -4.699999999999999
 |  | -17.75
 |  | -3.45
 |  | 1.5
 |  | -8.500000000000002
 |  | -5.199999999999999
 |  | -18.6
 |  | -0.6000000000000001
 |  | 0.7999999999999989
 |  | -8.200000000000001
 |  | -10.5
 |  | 3.050000000000001
 |  | -6.050000000000001
 |  | -8.400000000000002
 |  | -2.449999999999999
 |  | -2.149999999999999
 |  | -25.35
 |  | -12.35
 |  | -4.9
 |  | -3.300000000000001
 |  | -0.4500000000000011
 |  | -10.8
 |  | -14.1
 |  | -1.299999999999999
 |  | 0.8500000000000005
 |  | -8.25
 |  | -9.85
 |  | -4.700000000000001
 |  | -12.05