+ Reply to Thread
Results 1 to 2 of 2

Lookup multiple & non duplicated results for multiple matching criteria

  1. #1
    Registered User
    Join Date
    10-18-2012
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    2

    Lookup multiple & non duplicated results for multiple matching criteria

    problem.xlsx
    I need formula to allocate times for siblings in each group. there are 55 groups, with 22-25 children in each, some of them have 2,3,or 4 siblings.
    Appointment last 10 mins, then if siblings: I added 10 minutes time to get to another room for another app, if no siblin: only 5 min between app is needed.

    groups look like:(sheet SNST)
    child A Group A SIBLING GROUP C SIBLING A GROUP E
    child B Group A
    child C Group A
    child D Group A
    child E Group B
    child F Group B
    SIBLING GROUP C
    SIBLING A GROUP E

    siblings are in different groups, appointments for siblings look like that: (sheet times)
    (first sibling app is 8:40, second at 9:00 third at 9:20, then if 1st sibling app is at 8:55 next app is 9:15 then break and app resume at 10:15......
    app for 4 siblings must start when 4 time slots are available so parents dont have to wait during staff break or long lunch.
    I've got app times in a table:
    08:40 09:00 09:20
    08:55 09:15
    break
    10:15 10:30
    10:30 10:45 11:00 11:15 11:30
    10:45 11:05 11:25 11:45
    11:00 11:20 11:40
    lunch
    13:15 13:35 13:55 14:15 14:35
    13:30 13:50 14:10 14:30

    Siblings are in different groups and have appointments within 20 minutes.
    Then I've got all NON SIBLINGS: I can not use the app time allocated to any sibling who's in the same group as no sibling.
    Finally, when all students have app time allocated appointment in a group must be at least 15 minutes apart:(sheet HT)
    group A: child A 8:40 child B 9:00 Child C 9:15 (but not: app at 8:40 and next at 8:45)

    in cell E2 on sheet SNST I'm trying to use index/match and small bur getting times repeated in the same group!
    Could you help please?
    Thank you
    Last edited by melvil007; 10-19-2012 at 06:18 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Complicated appointment multi groups & selected slots for apps availab index/match/sma

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.


    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    Ben Van Johnson

+ 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