+ Reply to Thread
Results 1 to 8 of 8

Calculate hi-points

  1. #1
    Registered User
    Join Date
    10-07-2011
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    13

    Calculate hi-points

    Need help. This is really simple and I don't know how to do it. I am trying to calculate a hi point for a horse show. It is two judges each day over two days. A is the horses back number and B is the points that they earned.
    I need to consolidate the back number and add the total points that they have earned. Consolidate data does exactly what I need but even though I link to source data it doesn't update from having no back numbers entered, to showing them as I enter back numbers.




    This is what I have and this is what I want.

    A ........................B
    Back # ................. Points Earned
    154..........................6
    111..........................5
    112...........................4
    3...............................3
    88...........................2
    99...........................1

    154..........................6
    111 .........................5
    15............................ 4
    88............................. 3
    112............................2
    99............................1

    ...............

    There would be two more sets of columns and rows below just like this (One set for each judge)


    I want it to list the total points earned per horse in a different workbook, sorted by descending
    ie

    154..... 12
    111..... 10
    112..... 6
    88..... 5
    15...... 4
    3 ....... 3
    99....... 2

    This should be simple and I can't get it. Please help!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Calculate hi-points

    Look at the attached
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    10-07-2011
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Calculate hi-points

    Getting much closer...however, when I open the sheet, I would like only the point row to exist and I would fill in the back number column according to the points earned as the classes are placed one by one.

    So if a back number was changed the Summary would need to update automatically and sort as the total points changed each back number.
    Is this possible?
    Thank you so much for your help and quick reply!

  4. #4
    Valued Forum Contributor scottylad2's Avatar
    Join Date
    09-03-2010
    Location
    edinburgh
    MS-Off Ver
    Office 2007 Prof & Office 2010 Student Edition
    Posts
    629

    Re: Calculate hi-points

    Could you upload a sample of what you want? what you have now and what you would like it to do?
    Windows 7 using Office 2007 & 2010

    Remember your [ code ] [ /code ] tags, makes reading soooo much easier

  5. #5
    Registered User
    Join Date
    10-07-2011
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Calculate hi-points

    Here is an example. This is really what I would like to have it do but I would settle for anything that would make this job easier. I have been calculating points by hand on 600+ entry shows four times a year for the last four years and I'm getting desperate!
    Any change or difference in the way this is set up is fine as long as it would work. Thanks for the help all. I have very limited excel knowledge. I hope this is doable.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    10-07-2011
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Calculate hi-points

    Quote Originally Posted by alansidman View Post
    Look at the attached
    Why if I copy the eact formula in Score[1].xls can I not get the formula to work again on a different sheet?

  7. #7
    Registered User
    Join Date
    10-07-2011
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Calculate hi-points

    Okay...I have to type in the back number on the summary page to show the results for each back number. I need a formula that will give me the results AND the back number no the summary page in descending. Can I use a command button on the Summary page?

  8. #8
    Forum Contributor
    Join Date
    12-13-2007
    Location
    Central New York
    MS-Off Ver
    Home: 2007, Office: 2010
    Posts
    158

    Re: Calculate hi-points

    I highlighted the changes I made in Orange. I used the Rank function along with vlookup. I may point you in the right direction.

    Hope that helps,

    Mark
    Attached Files Attached Files

+ Reply to Thread

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