Results 1 to 6 of 6

Using RANK twice in a formula

Threaded View

  1. #1
    Registered User
    Join Date
    01-31-2008
    Posts
    10

    Using RANK twice in a formula

    I am currently running my own predictions league and can rank the teams in order of their Points total, but the problem is when points are equal, how do I separate them?
    I want to separate by Points Scores, then by % of correct results.

    For example if I have 2 players on 30 points; Player 1 has 55% correct, Player 2 has 50% correct,then Player 1 is top.

    I have enclosed an example of the final table.
    Rankings are obtained using a 'vlookup' from a separate worksheet.

    Thankyou, as always, for your continued assistance.

    Regards, Craig
    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