Lookup multiple & non duplicated results for multiple matching criteria
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
10:30 10:45 11:00 11:15 11:30
10:45 11:05 11:25 11:45
11:00 11:20 11:40
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?
Last edited by melvil007; 10-19-2012 at 06:18 AM.
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1