+ Reply to Thread
Results 1 to 2 of 2

Automatic League table (Not calculating Correctly)

  1. #1
    Forum Contributor
    Join Date
    MS-Off Ver
    At Work its 2010 At Home 2019

    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.

    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    Digital Nomad... based in Ireland
    MS-Off Ver
    ĶSoft Office 365. Learning Excel all over again!!

    Re: Automatic League table (Not calculating Correctly)

    In M3:

    In N3:

    In O3:
    Attached Files Attached Files

+ 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


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