Results 1 to 4 of 4

Updating League Tables automatically by inputting Results

Threaded View

  1. #3
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: Updating League Tables automatically by inputting Results

    Hi

    To put in same cell 1-1 will course problem sometime!!
    Best to add other column?
    Sample
    column A, team
    column B, score
    column C, score
    column D, team

    Use sumproduct and a DUMMYTABLES sheet in order get automatic on TABLES sheet.

    I done Under 11 and 11? Learn formula and see you can work on under 14 and 15?

    Any problem pm me.

    See the file.

    Regard
    To help you by my post? it would be nice to click on to say "Thank you".
    If you are happy with a solution to your problem?
    Click Thread Tools above your first post,
    select "Mark your thread as Solved".

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. Updating pivot tables automatically when leaving worksheet. Specific occurances only
    By DMBeer41 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2011, 11:51 AM
  3. Replies: 3
    Last Post: 05-08-2010, 08:47 AM
  4. Replies: 4
    Last Post: 07-04-2008, 07:53 PM
  5. updating tables automatically
    By Chris in forum Excel General
    Replies: 3
    Last Post: 10-07-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