Compiling a list from a data-set

[Aesynil]

So, I'm new to the forums, and lack a deep understanding of Excel. Just trying to help out some co-workers with something. Basically, what I am trying to do at the moment, is auto-generating our schedule based on the shifts we put into the spreadsheet. So, to clarify....


Sunday Monday Tuesday
Jim Works Off Works

Bob Off Works Works

Sandy Works Works Off


I'm looking for a function of some sort that could read everybody who works on Sunday, and put them into a list. So it could have a section that basically reads "Working Sunday: Jim, Sandy. Working Monday: Bob, Sandy, Working Tuesday: Jim, Bob" Is this possible with Excel? If so, a nudge in the right direction should be enough to get me going on it Thanks, all!

P.S. Our schedule is a fair bit more complicated then this, obviously, so I'm hoping if it's possible on a small scale I can make it apply on our full sheet.

P.S.S. I also thought it would be cool if there was some way to read it by person, and plug it into a calendar. So if Bob wanted a calendar of his work days, he could pulls his name up, and it would plug all of the days/times he works into the right spot on a calendar on another sheet, but that's just a curiosity if it's even possible.

[DonkeyOte]

P.S. Our schedule is a fair bit more complicated then this, obviously, so I'm hoping if it's possible on a small scale I can make it apply on our full sheet.

That is unlikely. Invariably the complexities dictate the most appropriate approach.

If you want practical / scalable solutions always ensure whatever data you provide (pref. by means of sample file) accurately reflects the real data in terms of: structure (layout), data types, ordering etc etc...