+ Reply to Thread
Results 1 to 4 of 4

Generate Name Roster From Date Cells Marked "X"

  1. #1
    Registered User
    Join Date
    12-06-2011
    Location
    Maine
    MS-Off Ver
    Excel 2010
    Posts
    10

    Generate Name Roster From Date Cells Marked "X"

    I'm trying to come up with a solution to creating a roster of kids who've signed up for summer camp. In the attached example, Section 1 is a list of kids. An "X" under the date means the child is attending that date. If possible, I'd like to create Section 2 that is an automatically generated roster of any kid who has an "X" under a given date. As each child is added to the Section 1 list, their name would have to find the next available blank in the appropriate Section 2 list.

    Section 1 formatting is not set in stone, so if I should reformat, that's fine.

    Thanks in advance.

    -Emily
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Generate Name Roster From Date Cells Marked "X"

    Here is a simliar topic you might find useful:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Please click the * icon below if I have helped.

  3. #3
    Registered User
    Join Date
    12-06-2011
    Location
    Maine
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Generate Name Roster From Date Cells Marked "X"

    Exactly the right solution. Thanks so much!

  4. #4
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Generate Name Roster From Date Cells Marked "X"

    Glad to help.
    As soon as I read this, I knew i had already solved something similar. Took me a while to find it, but easier than trying to figure it all out again.

+ 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