+ Reply to Thread
Results 1 to 9 of 9

Point allocating

  1. 05-25-2016, 03:38 AM #1
    TrendyUK
    TrendyUK is offline
    Registered User
    Join Date
    05-24-2016
    Location
    England
    MS-Off Ver
    2010
    Posts
    6

    Point allocating

    Hello all,

    I'm seeking some help I'm what you call an Excel idiot!

    I'm running a Euro 2016 Predictor and I've got the rules below set in place:

    10 Point's awarded for predicting the correct score for the both teams.

    7 Points awarded for predicting the correct result and the correct score for only 1 of the teams.

    5 Points awarded for a correct result, but the wrong score for both teams.

    2 Points awarded for the wrong result, but the correct score for 1 of the teams.

    I've created a formula which I've put below but the point are not allocating properly.

    Can someone please help me.

    =IF(COUNT('Fixtures & Results'!$G6:'Fixtures & Results'!$H6,'Michael Trenholme'!G6:H6)=4,(2*OR('Fixtures & Results'!$G6='Michael Trenholme'!G6,'Fixtures & Results'!$G6='Michael Trenholme'!H6))+(5*(SIGN('Fixtures & Results'!$G6-'Fixtures & Results'!$H6)=SIGN('Michael Trenholme'!G6-'Michael Trenholme'!H6)))+(3*AND('Fixtures & Results'!$G6='Michael Trenholme'!G6,'Fixtures & Results'!$H6='Michael Trenholme'!H6)),"")

    Thanks in Advance

    Michael
    Reply With QuoteRegister To Reply
  2. 05-25-2016, 03:41 AM #2
    humdingaling
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Point allocating

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 05-25-2016, 03:42 AM #3
    etaf
    etaf is online now
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,732

    Re: Point allocating

    Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
    We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

    To attach a file to your post,
    click "Go advanced" (next to quick post),
    scroll down until you see "manage Attachments",
    click that and select "Choose File" (top Left corner).
    Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  4. 05-25-2016, 04:27 AM #4
    TrendyUK
    TrendyUK is offline
    Registered User
    Join Date
    05-24-2016
    Location
    England
    MS-Off Ver
    2010
    Posts
    6

    Re: Point allocating

    I've attached the spreadsheet.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 05-25-2016, 04:28 AM #5
    TrendyUK
    TrendyUK is offline
    Registered User
    Join Date
    05-24-2016
    Location
    England
    MS-Off Ver
    2010
    Posts
    6

    Re: Point allocating

    If you need anything else please don't hesitate to let me know.

    Appreciate you rapid response on this.

    Michael
    Reply With QuoteRegister To Reply
  6. 05-25-2016, 04:29 AM #6
    TrendyUK
    TrendyUK is offline
    Registered User
    Join Date
    05-24-2016
    Location
    England
    MS-Off Ver
    2010
    Posts
    6

    Re: Point allocating

    If you need anything else please don't hesitate to let me know.

    Appreciate you rapid response on this.

    Michael
    Reply With QuoteRegister To Reply
  7. 05-25-2016, 04:59 AM #7
    José Augusto
    José Augusto is offline
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Point allocating

    I don't know if is this you want.
    Try this formula in J6 and copy down
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 05-25-2016, 05:17 AM #8
    TrendyUK
    TrendyUK is offline
    Registered User
    Join Date
    05-24-2016
    Location
    England
    MS-Off Ver
    2010
    Posts
    6

    Re: Point allocating

    You my friend are a legend! Thank you so much!
    Reply With QuoteRegister To Reply
  9. 05-25-2016, 05:19 AM #9
    José Augusto
    José Augusto is offline
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Point allocating

    Thanks for the feedback.
    Don't forget to mark this thread as SOLVED
    Regards
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Maths behind rotating rectangle around start point instead of default center point
    By Stanley91 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-08-2014, 11:01 AM
  2. [SOLVED] Allocating data by age
    By Steven T in forum Excel General
    Replies: 8
    Last Post: 05-28-2012, 09:55 AM
  3. Create a pareto chart with % line starting from top point of first data point
    By jeffreybrown in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-27-2011, 10:47 PM
  4. Allocating info
    By MikeNZ in forum Excel General
    Replies: 5
    Last Post: 08-03-2009, 12:30 PM
  5. [SOLVED] Allocating a value to text
    By Steve in forum Excel General
    Replies: 4
    Last Post: 02-19-2006, 02:10 PM
  6. Allocating a value from a cell
    By babygoode in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2005, 07:05 PM
  7. [SOLVED] Allocating a Value
    By Raymond Gallegos in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-06-2005, 10:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1