+ 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
    Office 365
    Posts
    471

    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
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    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




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ 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. [SOLVED] 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. [SOLVED] 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