+ Reply to Thread
Results 1 to 2 of 2

Help with CO-Ed Kickball lineup

  1. #1
    Registered User
    Join Date
    09-03-2020
    Location
    Huntsville, Al
    MS-Off Ver
    2013
    Posts
    6

    Help with CO-Ed Kickball lineup

    Ok so this has to be possible I want to list the Men and the Women in columns then have it auto place them in a lineup that goes Girl-Boy-Boy-Girl, Now I want the names to repeat because sometimes the girl appears more in the Lineup the boy because less girls and it has to go g-b-b. the list has to stay dynamic do to different numbers for different games.
    I got it to repeat fine. using:
    =IF(ISBLANK(INDIRECT("Sheet1!F"&ROW(F2))),INDIRECT("Sheet1!C"&(ROWS($C$2:C2)-(COUNTA(Sheet1!F:F)-2))),F2) BOYS
    =IF(ISBLANK(INDIRECT("Sheet1!I"&ROW(I2))),INDIRECT("Sheet1!C"&(ROWS($C$2:C2)-(COUNTA(Sheet1!I:I)-2))),I2) GIRLS
    I tried to do a if b2=girl then use the girl formula and the boy formula for false but I kept getting a #NAME error and when I did get it to work it only repeated the top 2 names......Please help this should be simpler I am missing something.....
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Help with CO-Ed Kickball lineup

    In think this is enough. With boy & girl unique List.

    Please Login or Register  to view this content.
    Attached Images Attached Images
    Attached Files Attached Files
    Quang PT

+ 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] Scalable baseball lineup from stats
    By lavudyar in forum Excel General
    Replies: 17
    Last Post: 08-03-2020, 04:22 PM
  2. Baskeball Lineup - Aggregate minutes
    By pantherdesigner in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-27-2019, 12:18 AM
  3. [SOLVED] MAcro that is doing a lineup and adding 5 lines
    By IonutC in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-16-2016, 10:56 AM
  4. Using solver to pick optimal basketball lineup
    By JesseM in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-08-2016, 10:26 PM
  5. [SOLVED] DFS Football lineup
    By stiffyslap in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-19-2015, 05:32 PM
  6. Optimize Basketball Lineup
    By rrmack34 in forum Excel General
    Replies: 6
    Last Post: 11-12-2014, 04:51 PM
  7. Optimizing a fantasy baseball lineup
    By zigzagman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-30-2014, 06:43 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1