Results 1 to 12 of 12

table that updates automatically with the name & highest score

Threaded View

  1. #1
    Registered User
    Join Date
    06-30-2009
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    6

    table that updates automatically with the name & highest score

    Ok, kinda noob to excel getting it to work out this stuff.

    I want to create a table that updates automatically with the name & highest score top.

    I.E. currently I have :-

    Dates starting in A4,
    names B2 : K2,
    scores B4 : K4,

    Not too fussed about having the date in the results table but i'd like something like :-

    Scott 4 points,

    Geoff 7 points

    Tony 2 points,

    I would like a table to automatically sort a table (preferably on sheet 2) so it looks like :-

    Geoff 7
    Scott 4
    Tony 2

    Is this possible ?, I only have 6 rows of data so far so it can be re-arranged if needs be and data will be added each week.

    Hopefully some clever person can help me lol.
    Last edited by geoffbanks; 06-30-2009 at 10:42 AM.

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