Results 1 to 9 of 9

Awarding Points In Standingss

Threaded View

  1. #1
    Registered User
    Join Date
    07-07-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    82

    Awarding Points In Standingss

    I want to have the column for "Points" in my sheet to provide .5 results for ties, instead of repeating the same number and then have the next points, based on scores, to drop in places and return a whole number. If the awarded points are for 28 places based on 28 scores, I want the ties to be totaled and return a .5 result.

    Abbreviating the rows, I'll use 6 places as an example. The sum of the points in the first example total 21. The sum in Example 2 total 20. The sum in example 3 total 21. I want my points to be like example 3.

    EX1      EX2       EX3
    A B      A B      A  B 
    6 1      6 1      6 1.0
    5 2      5 2      5 2.0
    4 3      4 3      4 3.0
    3 4      3 4      3 4.5
    3 5      3 4      3 4.5
    2 6      2 6      2 6.0
    Because there are other factors determining the standings, a simple RANK formula doesn't work.

    The following formula is what I am currently using that returns results like in EX 2. Is there a simple "add on" that I can incorporate into this formula?

    =IF(C4="G","",SUMPRODUCT((C$4:C$31<>"G")*(AH$4:AH$31<AH4))+1
    Last edited by shg; 08-25-2010 at 02:45 PM.

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