+ Reply to Thread
Results 1 to 4 of 4

Sheets Choose top 5 scores from multiple columns with conditions

  1. 01-30-2023, 05:17 AM #1
    hugowhere
    hugowhere is offline
    Registered User
    Join Date
    02-28-2014
    Location
    The Gambia
    MS-Off Ver
    Excel 2021
    Posts
    11

    Sheets Choose top 5 scores from multiple columns with conditions

    I am trying to automate a bowling statistics table. Each bowler has multiple games, one column for each.
    The problem I am having is that I am using =J1>=LARGE($J$3:$K$22, 4) in conditional formatting.
    I want to have it conditional for each men and women category. Also it should only calculate from the highest game of each player.
    What is happening as can be seen in the uploaded file is that it is counting both scores of one player if they had two top scores.

    Any suggestions would be appreciated.

    https://docs.google.com/spreadsheets...it?usp=sharing
    Reply With QuoteRegister To Reply
  2. 01-30-2023, 05:42 AM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2506 Win 11
    Posts
    24,900

    Re: Sheets Choose top 5 scores from multiple columns with conditions

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...ml#post5785379
    Last edited by Glenn Kennedy; 01-31-2023 at 06:54 AM.
    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
    Reply With QuoteRegister To Reply
  3. 01-31-2023, 06:53 AM #3
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Sheets Choose top 5 scores from multiple columns with conditions

    This is NOT a duplicate thread. I offered an Excel solution in the parallel thread. The OP subsequently changed their mind and wanted something that worked in GS. I ADVISED that they take EXACTLY this course of action.

    THREAD OPEN.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  4. 02-14-2023, 12:40 PM #4
    janmorris
    janmorris is offline
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,142

    Re: Sheets Choose top 5 scores from multiple columns with conditions

    @hugowhere,

    Your sample file is still restricted. we can not help in the file when it is locked.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
    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. [SOLVED] Choose top 5 scores from multiple columns with conditions
    By hugowhere in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-31-2023, 03:30 AM
  2. [SOLVED] count of two criteria in multiple sheets for golf scores
    By wyowhite in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-29-2020, 04:50 PM
  3. Transpose rows to columns and sort by scores (with repetitive scores)
    By anishmalhotra in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-02-2019, 08:17 PM
  4. [SOLVED] I need a macro to select range of scores, choose the best scores and apply a formula
    By hadleedog in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-12-2015, 03:15 PM
  5. [SOLVED] Calculating Standard Scores for a column with multiple conditions
    By kamelkid2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-08-2013, 10:37 AM
  6. Ranking scores/names from multiple sheets on summary page
    By Graphire in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-18-2008, 08:08 PM
  7. Calculating average scores from multiple sheets' information
    By quailhunter in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-16-2005, 05:37 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