Results 1 to 13 of 13

Rankings

Threaded View

  1. #1
    Registered User
    Join Date
    03-02-2009
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003
    Posts
    21

    Rankings

    Hi there,

    I have more issues with this spreadsheet, which is beginning to drive me bonkers. Its a rank issue, with a few problems, questions:

    Looking at the second table on the page, I want to rank the data for all colums except for column I in a descending fashion. IE - Highest to lowest. But column I needs to be ranked lowest to highest. I think I did this correctly, but I could be wrong.

    Is it possable for the rankings to record equals? IE, the TO column has that, but in REB there should be another tie (9th and 10th) but there is not.

    Further to this, the third table should have I28, and E35 listed as Ties. How do I do this for the entire table?

    Any help and ideas will once more, be appreciated greatly.

    Thanks.
    Attached Files Attached Files
    Last edited by Jabbitar; 03-27-2009 at 12:05 AM.
    Trying to make the perfect spreadsheet!

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