Results 1 to 58 of 58

Formula produces wrong result of top ten scores as it appears to dupicate the highest numb

Threaded View

  1. 02-01-2024, 01:22 PM #1
    Golfer2024
    Golfer2024 is offline
    Registered User
    Join Date
    02-01-2024
    Location
    new Zealand
    MS-Off Ver
    Ms Office 19
    Posts
    12

    Formula produces wrong result of top ten scores as it appears to dupicate the highest numb

    Formula produces wrong result of top ten scores as it appears to duplicate the highest numbers. The formula is as follows and is used to give the 10 best scores from more than ten games played. =SUMIF(L3:AJ3,">="&LARGE(L3:AJ3,10)) This formula was created using Excel in Office Package 19.
    Attached Files Attached Files
    Last edited by Golfer2024; 02-01-2024 at 06:35 PM.
    Reply With QuoteRegister To Reply
« 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. dupicate sheet with cell result changes
    By harbour1302 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-15-2017, 11:47 AM
  2. formula to keep only highest scores
    By tcdawg in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-20-2016, 02:51 PM
  3. [SOLVED] Eliminating Formula from Cell After it Produces a Result
    By nucky in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-18-2013, 04:28 PM
  4. formula for highest score, determined by sum of scores
    By patehi in forum Excel General
    Replies: 11
    Last Post: 11-26-2012, 09:53 AM
  5. Result of Formula produces Picture?
    By sharkman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-30-2006, 04:50 PM
  6. Fill down produces correct formula but wrong answer
    By Jim at SDSU in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-03-2006, 03:10 PM
  7. [SOLVED] FORMULA PRODUCES WRONG RESULT
    By Wildebeest222 in forum Excel General
    Replies: 2
    Last Post: 10-11-2005, 05:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1