Results 1 to 5 of 5

Automatic Records Table Sort?

Threaded View

  1. #2
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    Sunderland, England
    MS-Off Ver
    Excel 2007 (Home) / 2003 (Work)
    Posts
    740

    Re: Automatic Records Table Sort?

    It's not super elegant, but it'll do the job.

    This will sort the table by points, then (if a tie) win %, then goal difference, then goals scored. Note the original table has been moved to rows 81-88 (and is probably best hidden), then a new table added which uses VLOOKUPs to pull the data back from the original with the help of a new column (A).

    I hope this helps.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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