+ Reply to Thread
Results 1 to 3 of 3

Creating lists based on matching criteria

Hybrid View

  1. #1
    Registered User
    Join Date
    08-27-2013
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Creating lists based on matching criteria

    I work for a college. My students study 5 classes through a 5 semester program, however they can mix their classes/semesters around, not necessarily studying classes 1-5 in order.

    I have created a summary page where I record their name and their start date for each class. On the worksheet there are also tabs relating to each semester which will provide me with a snapshot of who is enrolled in each class in that particular semester.

    I know I can use filters on the summary page to see who is in a particular class, however I want to use formulas to populate class lists with names so I can view all the class lists at once for any given semester.

    I have uploaded a very simplified version of the worksheet.

    I would like the table at the bottom populated with lists of names based on who is in which class in Jan-13, however I can't seem to get any formulas to work for me to do this.

    Any help would be greatly appreciated!Test.xlsx

  2. #2
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: Creating lists based on matching criteria

    You can try this file.

    Note: Please modify the date marked in red.
    Attached Files Attached Files
    Last edited by ramananhrm; 08-28-2013 at 12:01 AM.
    Please click 'Add reputation', if my answer helped you.

  3. #3
    Registered User
    Join Date
    08-27-2013
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Creating lists based on matching criteria

    Great. Thank you Ramanan.

    The formulas you gave me worked well and I was able to use them in my worksheet.

    I appreciate your help.
    Last edited by Sam.T; 08-28-2013 at 07:58 PM.

+ 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. creating VB code using advanced search criteria with multiple data validation lists?
    By Jonathan Bay in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-14-2011, 09:56 AM
  2. Replies: 0
    Last Post: 12-20-2010, 04:31 PM
  3. Replies: 3
    Last Post: 09-02-2010, 03:04 AM
  4. [SOLVED] Creating Lists Based on Other Lists
    By amyxkatexx in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2010, 01:50 PM
  5. Creating lists based on category
    By NearClueless in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-10-2009, 04:02 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