+ Reply to Thread
Results 1 to 4 of 4

League Table auto update RANK goes lower than avaliabe on table

  1. #1
    Registered User
    Join Date
    08-04-2019
    Location
    England
    MS-Off Ver
    365
    Posts
    6

    League Table auto update RANK goes lower than avaliabe on table

    I am creating a league table that auto updates based on the fixtures sheet, as well as allowing the user to select a number of teams to use in table.

    However due to the number of teams being customisable it is messing with the RANK system that I am using, as if a team is on 0 points but is losing games then there rank will be lowered but due to there being more teams in the dummy sheet this means that if you have a league of 13 teams, then the team that loses will be ranked lower than 13 and as such will not show on the table and would be replaced by a blank team (shown as a 0).

    Is there anything I can do to get the unused ranks to don't show up and as such make it so that if 13 teams is selected then the lowest rank to use is 13 but if 34 teams is selected then all 36 ranks will be used.

    Any help will be appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,256

    Re: League Table auto update RANK goes lower than avaliabe on table

    Hello killhi12 and Welcome to Excel Forum.
    Try modifying the formula in the RANK column on the Dummy Table sheet to read: =IF(ISTEXT(C4),SUM(E4:I4),"")
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    08-04-2019
    Location
    England
    MS-Off Ver
    365
    Posts
    6

    Re: League Table auto update RANK goes lower than avaliabe on table

    Thanks for the reply JeteMc, that new formula works perfectly, and I understand what it does and how to use it so that is a plus as well, so thanks again for your time in helping me with the problem.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,256

    Re: League Table auto update RANK goes lower than avaliabe on table

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ 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. Hi Every one Rank Lawn green bowling league table
    By jtd Clarke in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-07-2016, 05:14 AM
  2. [SOLVED] Rank League Table ignoring BYE
    By kevinmcilroy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-20-2014, 03:21 PM
  3. Rank League Table
    By adam2308 in forum Excel General
    Replies: 3
    Last Post: 03-19-2014, 03:23 PM
  4. league table update
    By daniel.thomas10 in forum Excel General
    Replies: 1
    Last Post: 04-27-2010, 01:22 PM
  5. create league table :: enter result :: update table
    By Eng.Soly in forum Excel General
    Replies: 2
    Last Post: 12-27-2008, 06:31 AM
  6. update league table
    By stevesunfold in forum Excel General
    Replies: 8
    Last Post: 08-17-2008, 07:24 AM
  7. League table automatic sort/update
    By RedHook in forum Excel - New Users/Basics
    Replies: 23
    Last Post: 05-18-2006, 09: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