Ranking numbers

Giganews Newsgroups
Subject: Ranking numbers
Posted by:  Joff
Date: Thu, 16 Aug 2007

I need to rank the following numbers:

Entered Values          What Excel has ranked          What I actually want
        1                                    2
        2
        15                                  7
        7
        28                                  9
        9.5
        5                                    4
        4
        28                                  9
        9.5
        10                                  6
        6.5
        10                                  6
        6.5
        2                                    3
        3
        0                                    1
        0
        56                                  10
      10

This is for a fishing score data. The weight is the 'Entered Values' (and is
changeable week to week). I can get around the '0' that i actually want
(there might of course be another way), but am really struggling to get the
..5's sorted. Any help will be greatly apprieciated.

Replies