+ Reply to Thread
Results 1 to 2 of 2

Automatic League table (Not calculating Correctly)

  1. #1
    Forum Contributor
    Join Date
    04-06-2017
    Location
    Wolverhampton
    MS-Off Ver
    At Work its 2010 At Home 2019
    Posts
    362

    Automatic League table (Not calculating Correctly)

    hello All

    I want a table that self-updates from the data in pink, I want the submissionís to count lo how submissions thatís been submitted, But itís the points Colum that needs to determine the league position.

    Iíve had ago and but there is an error as Paul Walker appears 3 times and it should only be once as to the table in yellow.

    Paul
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    New learning curve! Office 365
    Posts
    25,384

    Re: Automatic League table (Not calculating Correctly)

    In M3:
    =IFERROR(INDEX($C$3:$C$20,MATCH(O3,INDEX(SUMIFS($D$3:$D$20,$C$3:$C$20,$C$3:$C$20)*(COUNTIF($M$2:$M2,$C$3:$C$20)=0),0),0)),"")

    In N3:
    =IF(M3="","",COUNTIF($C$3:$C$49,M3))

    In O3:
    =IFERROR(1/(1/LARGE(INDEX(SUMIFS($D$3:$D$20,$C$3:$C$20,$C$3:$C$20)*(COUNTIF($M$2:$M2,$C$3:$C$20)=0),0),1)),"")
    Attached Files Attached Files
    Glenn



+ 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. Pivot Table field not calculating correctly
    By govcam in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-07-2015, 04:39 PM
  2. [SOLVED] automatic updating a sports league table
    By dabaron in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-29-2013, 09:39 AM
  3. Automatic Sorting in Sports League Has Glitch
    By daharmattan1 in forum Excel General
    Replies: 1
    Last Post: 05-20-2012, 09:11 AM
  4. Replies: 0
    Last Post: 11-29-2009, 08:41 AM
  5. League table automatic sort/update
    By RedHook in forum Excel - New Users/Basics
    Replies: 23
    Last Post: 05-18-2006, 09:50 AM
  6. Automatic League Sort
    By Blade2304 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-18-2006, 09:45 AM
  7. Create Formula for calculating Little League Age...
    By Brent in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-20-2005, 09:05 PM

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