+ Reply to Thread
Results 1 to 9 of 9

Top 4 Male and Top 4 Female scores WITH 4 more top scores added

  1. #1
    Registered User
    Join Date
    03-29-2016
    Location
    Tupelo, MS
    MS-Off Ver
    2010
    Posts
    4

    Top 4 Male and Top 4 Female scores WITH 4 more top scores added

    Hello. I have had this issue for 3 years now. I need the Top 4 Male and Top 4 Female Archery scores WITH 4 more top scores of any gender ADDED, Listed by RANK order. I have a spreadsheet to upload to work on. There are a lot of "Helper" cells for brainstorming. I want to see if I am on the right track.
    Attached Files Attached Files
    Last edited by shinobi09; 03-31-2016 at 02:06 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: Top 4 Male and Top 4 Female scores WITH 4 more top scores added

    Hi

    Welcome to the forum

    Male top 4
    Cell X6
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Copy down and cross.

    Done the same with female cell AA6

    See the file

    Regard
    Attached Files Attached Files
    To help you by my post? it would be nice to click on to say "Thank you".
    If you are happy with a solution to your problem?
    Click Thread Tools above your first post,
    select "Mark your thread as Solved".

  3. #3
    Valued Forum Contributor
    Join Date
    08-22-2011
    Location
    Auckland
    MS-Off Ver
    Excel 2019
    Posts
    716

    Re: Top 4 Male and Top 4 Female scores WITH 4 more top scores added

    Hi shinobi09

    I'm not much good at formulas so I did a VBA solution. As it is now it pastes the results onto sheet 2 but the code can be changed to paste it anywhere.
    There's a button on Sheet 1 to press to see what it does & if it's what you want etc. If you like it it can be changed to a worksheet change macro so no button pressing will be required.
    Let me know if you want it changed etc
    The website STILL WONT LET ME UPLOAD A WORKBOOK. Not shouting at you, shouting at the people who ain't doing anything about it.
    A dropbox link is below to download

    https://www.dropbox.com/s/qm7k5mgfxr...late.xlsb?dl=0

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    03-29-2016
    Location
    Tupelo, MS
    MS-Off Ver
    2010
    Posts
    4

    Re: Top 4 Male and Top 4 Female scores WITH 4 more top scores added

    micope21

    Thanks. This is great, and on the right track. But after this I want it to list the RANK, Like 4 top Male and the 4 top Female WITH the NEXT 4 Top scores: So 12 scores in all. They will mix different everytime we have a match. I want it to sort the 12 scores together by RANK. could be 8M and 4F; 7M and 5F; 6M and 6F; 5M and 7F; 4M and 8F. They may sometimes NOT be the 12 Top scores but I have to count TOP 4M, TOP 4F, then 4 top scores AFTER that, which may be M or F. AT LEAST 4 scores need to be of the opposite ***.

  5. #5
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,368

    Re: Top 4 Male and Top 4 Female scores WITH 4 more top scores added

    here, try this
    Attached Files Attached Files
    Last edited by Phuocam; 04-02-2016 at 11:46 PM.

  6. #6
    Registered User
    Join Date
    03-29-2016
    Location
    Tupelo, MS
    MS-Off Ver
    2010
    Posts
    4

    Re: Top 4 Male and Top 4 Female scores WITH 4 more top scores added

    @Phuocam That works IF I ONLY wanted the Top 4 males and females scores. AT LEAST....There maybe ONLY 4 females like this scenario, but not always. It will depend on the scores, of course. Could be 8M and 4F; 7M and 5F; 6M and 6F; 5M and 7F; 4M and 8F. They may sometimes NOT be THE 12 Top scores but I have to count TOP 4M, TOP 4F, then 4 top scores AFTER that, which may be M or F. AT LEAST 4 scores need to be of the opposite gender.

  7. #7
    Registered User
    Join Date
    03-29-2016
    Location
    Tupelo, MS
    MS-Off Ver
    2010
    Posts
    4

    Re: Top 4 Male and Top 4 Female scores WITH 4 more top scores added

    @Phuocam That works IF I ONLY wanted the Top 4 males and females scores. AT LEAST....There maybe ONLY 4 females like this scenario, but not always. It will depend on the scores, of course. Could be 8M and 4F; 7M and 5F; 6M and 6F; 5M and 7F; 4M and 8F. They may sometimes NOT be THE 12 Top scores but I have to count TOP 4M, TOP 4F, then 4 top scores AFTER that, which may be M or F. AT LEAST 4 scores need to be of the opposite gender. ONLY thoses 5 scenarios.

  8. #8
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,368

    Re: Top 4 Male and Top 4 Female scores WITH 4 more top scores added

    Sorry,try again...
    Attached Files Attached Files

  9. #9
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: Top 4 Male and Top 4 Female scores WITH 4 more top scores added

    Hi

    I think this will do and no array formula?
    See the file
    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)

Similar Threads

  1. [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
  2. Replies: 8
    Last Post: 12-20-2014, 04:37 PM
  3. Replies: 1
    Last Post: 06-15-2013, 09:02 PM
  4. [SOLVED] List the most recent five scores from among multiple scores
    By Winship in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-11-2012, 09:25 PM
  5. VB macro for sorting through scores and copying certain scores to new sheet
    By cowboy713 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2010, 01:47 AM
  6. Names and scores of the two lowest scores
    By dmyoungsal in forum Excel General
    Replies: 3
    Last Post: 07-15-2008, 11:47 AM
  7. how to add weekly scores w/o showing current scores
    By breal33 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-02-2007, 11:56 PM

Tags for this Thread

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