Results 1 to 8 of 8

Breaking ties with rank alphabetically

Threaded View

  1. #1
    Registered User
    Join Date
    10-24-2011
    Location
    here
    MS-Off Ver
    Excel 2007
    Posts
    8

    Breaking ties with rank alphabetically

    hello,

    I have a workbook in which I have a statistic sheet that uses the rank function to return the top 4 students in a number of categories.

    The ranks themselves are okay, but I also have the students name being referenced.

    This becomes a problem because in the event of a tie, it returns the same students name for each instance.

    Is there a way to have the names of each student involved in the tie listed alphabetically rather than have the same student listed each time?

    I have attached the workbook, since im sure little of what I explained makes sense..

    Thanks a lot for any help!
    Attached Files Attached Files

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