+ Reply to Thread
Results 1 to 6 of 6

3 league tables (f1)

Hybrid View

  1. #1
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,720

    Re: 3 league tables (f1)

    Try

    in G3

    =INDEX('Race Scores'!$F$17:$F$34,MATCH(LARGE('Race Scores'!$F$17:$F$34,ROWS($1:1)),'Race Scores'!$F$17:$F$34,0))

    copy down

    in B3

    =INDEX('Race Scores'!A$17:A$34,MATCH($G3,'Race Scores'!$F$17:$F$34,0))

    copy across to F and down

    format columns C to F to suppress (hide) zeros

    as CUSTOM

    0;0;;@

    Repeat similar formulae for other tables

    See sheet "League table2" in attached
    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. [SOLVED] Help with football league tables, need to add 2 tables together!
    By ferdowsi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-10-2013, 01:13 PM
  2. League Tables
    By Jack in forum Excel General
    Replies: 1
    Last Post: 12-14-2005, 10:25 AM
  3. [SOLVED] League Tables
    By Howard in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-07-2005, 12:05 AM
  4. League Tables
    By Howard in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 09:05 PM
  5. [SOLVED] League Tables
    By Howard in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 PM
  6. [SOLVED] League Tables
    By Howard in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  7. League Tables
    By Howard in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 PM
  8. League Tables
    By Howard in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12: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