+ Reply to Thread
Results 1 to 4 of 4

World Cup Group Ranking (Yes I know, another World cup Thread)

  1. #1
    Registered User
    Join Date
    05-07-2013
    Location
    australia
    MS-Off Ver
    Excel 2010
    Posts
    9

    World Cup Group Ranking (Yes I know, another World cup Thread)

    Hi Guys,

    So, what I wanted to do was have a ranking next to each group so I can pre-populate all my data as the games are played..


    Below is what my table is returning (R=Rank, G=Group, rest are self explanitory)
    This is based off the first 2 games having the following result (to test)
    Brazil 1 vs Croatia 0
    Mexico 1 vs Cameroon 2

    A B C D E F G
    R G Team GF GA GD PTS
    2 A Brazil 1 0 1 3
    6 A Mexico 1 2 -1 0
    1 A Cameron 2 1 1 3
    8 A Croatia 0 1 -1 0


    =RANK(G2,$G$2:$G$5)+(SUMPRODUCT(--($F$2:$F$5>F2)))+(SUMPRODUCT(--($D$2:$D$5>D2)))
    however instead of giving me ranks of 1,2,3,4 its goign 1,2,6,8

    Attached is a copy of the spreadsheet (with all my works tipping and stuff removed)
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-07-2013
    Location
    australia
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: World Cup Group Ranking (Yes I know, another World cup Thread)

    Sorry, the part im trying to sort rank properly is the 2nd tab, at the group stages.

    yes, i know there is ALOT of cross referancing on this spreadsheet LOL!

  3. #3
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: World Cup Group Ranking (Yes I know, another World cup Thread)

    Hi

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    This one will give you 1,2,3,4.

    Regard
    micope21
    To help you by my post? it would be nice to click on to say "Thank you".
    If you are happy with a solution to your problem?
    Click Thread Tools above your first post,
    select "Mark your thread as Solved".

  4. #4
    Registered User
    Join Date
    05-07-2013
    Location
    australia
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: World Cup Group Ranking (Yes I know, another World cup Thread)

    Thanks Heaps!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Hello World !
    By 4hm4dfudz41l in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-19-2013, 01:08 AM
  2. hello world!
    By aidda in forum Hello..Introduce yourself
    Replies: 4
    Last Post: 05-24-2013, 02:23 PM
  3. Hello World
    By The Bidds in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 03-15-2013, 05:18 AM
  4. Hello to the world
    By Ambiensse in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 03-09-2013, 06:58 PM
  5. Hello world!
    By buynowhhh in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-04-2012, 05:50 AM

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