+ Reply to Thread
Results 1 to 4 of 4

Rank Duplicate Values Sequentially

  1. #1
    Registered User
    Join Date
    09-16-2008
    Location
    Chicago, IL
    Posts
    30

    Rank Duplicate Values Sequentially

    I have a data set and I want to Rank Duplicate Values Sequentially without using an array function. Here is an example that I'm trying to achieve.

    Region-Value-Rank
    East-20-3
    West-30-2
    North-35-1
    South-20-4
    Central-15-5
    Midwest-10-6

    It does not matter if East gets 4 and South gets 3. I just want them to return different ranks rather than same.

    Regards,
    Kalyan Verma

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Rank Duplicate Values Sequentially

    One approach is to use RANK + COUNTIF

    Please Login or Register  to view this content.

  3. #3
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Rank Duplicate Values Sequentially

    Have a look at this link, particularly Unique Ranks in Descending Order. hth.

  4. #4
    Registered User
    Join Date
    09-16-2008
    Location
    Chicago, IL
    Posts
    30

    Re: Rank Duplicate Values Sequentially

    Thanks "DonkeyOte" it helped and works like a charm.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1