+ Reply to Thread
Results 1 to 4 of 4

List Ascending Order shows duplicates

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Sheffield, England
    MS-Off Ver
    Excel 2010
    Posts
    117

    List Ascending Order shows duplicates

    Hi - I have a formula which lists users in descending order based on their performance stats. However, if someone has the same performance figure as another user, then it lists the same user again.

    =OFFSET(INDEX(Rank_Total,MATCH(SMALL(COUNTIF(Rank_Total,">"&Rank_Total),ROW(1:1)),COUNTIF(Rank_Total,">"&Rank_Total),0)),0,-9)
    Can this formula be tweaked to list the other users who have the same figure as someone else in the range?

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: List Ascending Order shows duplicates

    id user a helper to rank them uniquely then pull that back in ascending order
    Last edited by martindwilson; 04-06-2012 at 05:10 AM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Sheffield, England
    MS-Off Ver
    Excel 2010
    Posts
    117

    Re: List Ascending Order shows duplicates

    Hi - could you give me an example of how this would work?

    Kind regards
    Tom

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: List Ascending Order shows duplicates

    sorry for delay..in pub lol
    Attached Files Attached Files
    Last edited by martindwilson; 04-06-2012 at 05:09 AM.

+ 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