Schedule Formula - Please Help - Thanks

[Schedule Formula - Please Help - Thanks!]

Hello Bob or anyone else that can help figure this out...thanks!!

If I have someone scheduled for a double shift on one day, the 1st set of
hours appear but the second doesn't. Is there a function to get 2 results
in the same box? Beaudreau - wed 9/2, 3pm / 11pm shifts. Maybe a rept or
should i double the formula? You are really good at this, thought I ask
versus take another 6 days trying to experiment. Thanks!!!

Karen

 

[Max]

It seems you have a list of names (eg: Beaudreau, Jean, etc) listed in
B5:B28, with corresponding info listed in col A next to the names. This
formulas play will extract multiple col A info (for names duplicated within
B5:B28, if any) and display the multiple results horizontally aligned with
the names that you list in A31 down as lookup values.

Here's the play:
List all the unique names (eg: Beaudreau, Jean, etc) in D4 across to say Z4,
in any order

Put in D5: =IF($B5="","",IF($B5=D$4,ROWS($1:1),""))
Copy across/fill down to Z28

You have the unique names to be looked up
listed in A31 down, eg: Beaudreau, Jean, etc

Place this in B31
=IF(ISERROR(SMALL(OFFSET($C$5:$C$28,,MATCH($A31,$D$4:$Z$4,0)),COLUMNS($A:A))),"",INDEX($A$5:$A$28,SMALL(OFFSET($C$5:$C$28,,MATCH($A31,$D$4:$Z$4,0)),COLUMNS($A:A))))

Copy B31 across by say, 5 cols? to cover the max expected repeats per any
unique name (within B5:B28), then fill down as far as required. The multiple
results for any duplicated names will appear horizontally aligned, neatly
bunched to the left. Any good? Hit the YES below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik