Find out who is working today.

[fsorto90]

I have a spreadsheet where I make a standard weekly schedule. What I would like to do is in another sheet have the people working that day(Today) automatically populate a list. Icing on the cake would be if i could also get there scheduled times to populate the column next to there names. I have tried doing it with VLOOKUP but it returns only the scheduled hours.schedule.xlsx

[Richard Buttrey]

Hi,

See attached

I've reformatted your data so that you can use a Pivot Table

Select the date you're interested in from the drop down in B2 on the PT.

[ChemistB]

Here is a solution direct from your table. It's very complex though.

For People, use an Arrayed formula

Please Login or Register  to view this content.

For Hours,

Please Login or Register  to view this content.

See Attached.

[fsorto90]

Is there any way to use a pivot table and leave the data the way it is?

[fsorto90]

Would it be more simple to use a macro?

[Richard Buttrey]

Is there any way to use a pivot table and leave the data the way it is?

In short, no. The pivot table needs the layout i showed.

If you think about it though the data is essentially no different, just laid out in a list rather than the table you showed. the important thing with a PT is to ensure that every column contains a unique set of information, which is why you can't have dated spread out across the columns.

Think about it though. A PT doesn't need any formulae or macros to work and it is so much more powerful since you can just drag and drop fields of information around and see different presentations and summaries should you have any numeric data.