Results 1 to 12 of 12

autosort formula

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2012
    Location
    Amsterdam
    MS-Off Ver
    Microsoft 365
    Posts
    35

    autosort formula

    hi all,
    (I hope my english is good enough to make an understandable post)
    I have a question and I just cant figure out the answer myself.
    Ive made a worksheet for a soccer poule EC 2012.
    Everything is working fine, score are calculated correctly etc.

    Theres just one little tiny thing I cant figure out.
    There are several worksheets.
    worksheet 1 is all competitors, their results and their scores.

    Now in worksheet 2 ive made a scorelist, pretty simple, just refers to worksheet 1, only in a nice overseight. just 2 rows, row 1 name, row 2 score all refering to worksheet 1.
    Works good, no problems so far.
    But what I want is that I can autosort from z to a in row 2 (scores). So the number 1 is first, number 2 second etc.
    Of course I can change it myself every time, but I want it automatically to be changed as soon as worksheet 1 changes.

    example:
    I fill in results of matches in sheet 1, as a result of that the score changes and "mark" had now 80 points and "george" 81
    In sheet 2 the scores change, but mark with 80 points is still the first mentioned.

    Hope I made myself clear and I really hope someone can help me here, since its making me crazy :P

    Thx in advance
    Last edited by gittermaster; 06-21-2012 at 04:41 PM.

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