+ Reply to Thread
Results 1 to 4 of 4

sorting names with total scores

  1. #1
    Registered User
    Join Date
    10-22-2013
    Location
    Ayr, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    20

    sorting names with total scores

    Hi All

    I hope someone can help me, I have another post on creating a score sheet, but still looking for solutions.
    I am trying this my self but have this annoying thing preventing me from starting.

    Here is my first problem

    I receive scores from our comp sec of members names and scores given per photo
    some member may have up to 3 individual scores per competition

    Image Title Author Placed Points

    Puddle Jumper Harry Cant 1st 20
    Finally A Cure Fo Robert Holloway 2nd 19
    Skyes The Limit Harry Cant 3rd 18
    Run This Way Tam Jean Shaw 4th 17
    Siesta Time Jean Shaw 5th 16
    Tranquility Jean Shaw 6th 15
    PPPPPPPenguin Julie McMahon 7th 14
    Picnic In The Rain Harry Cant 8th 13
    Tower In Bloom Julie McMahon 9th 12
    Window Decor Andrew McLaughlin 10th 11
    Oval Light Andrew McLaughlin 11th 10

    As you can see, some members have more than 1 entries, is there a way to, look at the list and auto populate with members name and total of combined scores, this is really doing my head in.

    If I can get help with this, it will help with my score sheet on another post

    Thanks in advance

    Johnny

  2. #2
    Registered User
    Join Date
    10-22-2013
    Location
    Ayr, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: sorting names with total scores

    As you can see

    Jean Shaw has 3 entries scoring 15,16,17

    My preferred output after function

    Jean Shaw 48

    And do the same for all members

  3. #3
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: sorting names with total scores

    To solutions here, Pivot Table or SUMIF.
    Attached Files Attached Files
    Last edited by Jacc; 10-24-2013 at 05:16 PM.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  4. #4
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: sorting names with total scores

    Hmm... some attachement issue here. Let's try again.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-22-2013
    Location
    Ayr, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: sorting names with total scores

    Thanks Jacc for your help, one solved many to go

+ 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. VB macro for sorting through scores and copying certain scores to new sheet
    By cowboy713 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2010, 01:47 AM
  2. Total only the 7 largest scores in range of 10
    By bobbby1949 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 09-02-2010, 03:16 PM
  3. Names and scores of the two lowest scores
    By dmyoungsal in forum Excel General
    Replies: 3
    Last Post: 07-15-2008, 11:47 AM
  4. Total Lowest Scores
    By dmyoungsal in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-20-2007, 05:20 PM
  5. Sorting names and numbers in order with the highest total
    By Red Shoes in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-23-2006, 04:30 AM

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