Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Ranking Numbers (2003)

    Greetings,

    I have a situation where I need to Rank a series of numbers. I would like the macro to traverse through the list, apply the rank. There will be duplicates, and these would all receive the same rank.

    example:

    Points
    93
    84
    78
    75
    66
    62
    61
    60
    59
    59
    57
    57
    55
    55
    53
    53
    52
    52
    50
    50
    50


    Result would be:

    Points
    93 1
    84 2
    78 3
    75 4
    66 5
    62 6
    61 7
    60 8
    59 9
    59 9
    57 10
    57 10
    55 11
    55 11
    53 12
    53 12
    52 13
    52 13
    50 14
    50 14
    50 14

    Etc... until end of list.

    Thanks Brad

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Ranking Numbers (2003)

    If the rankings are going to be sorted descending your don't need a macro, you could use a formula:

    Assuming the first value is in A2
    =IF(A2=A1,B1,B1+1)

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Ranking Numbers (2003)

    That did it.

    Many thanks!!!!


    Brad

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •