+ Reply to Thread
Results 1 to 3 of 3

Formula worked in Excel 2003 but doesn't in 2010.

Hybrid View

retiredjhawk Formula worked in Excel 2003... 08-29-2012, 12:07 AM
romperstomper Re: Formula worked in Excel... 08-29-2012, 06:54 AM
retiredjhawk Re: Formula worked in Excel... 08-29-2012, 11:39 AM
  1. #1
    Registered User
    Join Date
    08-01-2007
    Posts
    40

    Formula worked in Excel 2003 but doesn't in 2010.

    When I used this particular formula (in P29 on each golfer's sheet) the past few years, I was using Excel 2003. Now I am using 2010 and the formula to determine a golf handicap doesn’t work. I have between 0 to 16 weekly TOTAL scores for each golfer. I need to find the best 5 out of the last 10 to figure the final handicap. In the past, the scores filled rows 12 or 13 to 29; this year my scores ended on row 28. I thought I could just change the 29 to 28 in the formula and it would work but it doesn’t. Why? You will see that I changed the formula (in P29) for Anderson and Arnold to 28. The others are the original formula with the 29. There is an ! (that pops up in O29) saying, a value used in the formula is of the wrong data type. I don’t know what that means. I have attached my spreadsheet.
    Attached Files Attached Files

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,972

    Re: Formula worked in Excel 2003 but doesn't in 2010.

    It's an array formula and you need to press Ctrl+Shift+Enter when entering it rather than just Enter. You will know if you do it correctly because Excel will automatically enclose the formula in {} (do not enter these yourself!)
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Registered User
    Join Date
    08-01-2007
    Posts
    40

    Re: Formula worked in Excel 2003 but doesn't in 2010.

    I'm sorry I didn't explain myself well. I thought I had attached the entire workbook and indicated what the "!" in O29 (if that is a code) showed on my screen. Thanks for your help. It works fine now that I changed the 29 to 28 and did the ctrl+shirt+enter.

+ 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