formula to display only the persons concerned

Welcome to the forum.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Could you please provide a much smaller dataset with clear annotations, as I requested above? You also need to show us some expected results. Thanks.

On 16/7, Period 1 there are 39 names with Xs. There are 12 columns x 6 rows = 72 places in the FIRST table alone. Yet you have all 72 places filled.

Please explain the role of the time slot in making the allocations, as it is currently NOT described at all.

I hope that answers your question

No, it doesn't. I asked for a cut-down version of the workbook, but never mind.

I just made a small demonstration of the expected result on the sheets Result 1 and Result 2
Thank you very much for your help

Hahaha. I am now totally lost!!

So am I - far too big a workbook to wade through, I am afraid.

Take a step back and answer my Q's at post 9. It seems to have confused an earlier helper, too.

I can populate the first line of the first table easily enough... but I have no idea what timeslots 2, 3, 4, etc, have to do with anything.

I have a feeling that I will have to give up.

Christopher Fétique in time slot 1 appears in 2 places. Cells R5 & H30. How? Why? Help!!

This is precisely why I asked for a simplified version of your data! Sample data should NEVER contain mistakes. You MUST take care when preparing it: focus on a small, representative sample.

See Post 18!!

For some reason, I cannot download the file. When I try, the EF tells me I need to log in... despite the fact that I'm logged in!!

EESH -

What is this for?

You are trying to just get a Schedule when you select who the Volunteer is...

You want it to lookup the schedule from your Matrix "Job Schedule" and return the TimeSlot relevant and the Zone it applies to

Would you be opposed to VBA? I may not have time to return to this until Sunday/Monday...

But I would recommend VB to do a lookup of the values you select for your Results.

Say you choose the name and period... not sure I see what the period is doing when I took a peek... but lets start with the Volunteer...

You choose "Christian Auch" and then you run the code... the code should do a .Cells.Find(What:=Volunteer), and then loop through each volunteer it finds. As it finds the volunteer it will capture the row and column, this row and column are key to identifying the ROW = Time Slot and COL = ZONE.

Using these you would write the vb to first write in what the TS is that it found, the Zone and then find next until it runs out... building this view you have on the results.

Not sure why you have Spots and Zones when the Zone seems to be a default string until someone is actually paused... but the VB can write it in as you see fit.


Be mindful that you are building this list every time so you will need to first reset the list (Clear It) then build it until it runs out at which time it can write in End of Matches, Site Cleaning, Site Cleaning.

The list should have a max range that it could possibly go to... I would personally use conditional formatting to say if cell is not blank be a color with a border of choice.
You can add it to the VB but I personally prefer conditional formatting when it is a small range of items with a persistent format.