Need help to skip blanks in repeated list formula (index match)

Hi Team,

Let me try to explain my situation as best I can

I have 4 people working on a worklist that gets split evenly across all people.

There are checkboxes on the worksheet working as an "Role Call" this simply writes the persons name that's ticked into Cell H1-H4

The first row (Row 3) picks up the first agent which is all well and good,

Please Login or Register  to view this content.

The second Row (row 4) is the formula that spreads the worklist evenly over all people who have been down H1-H4

Please Login or Register  to view this content.

Now this works perfectly, except if for example where if only Agent 1 and Agent 3 are ticked it'll only display the First person as if it finds a blank it reverts to previous name found.. How can I have it search through the list of 4 people?

Hope that makes sense,

Regards

Hi AliGW.

Thanks for your reply and the warm welcome.

I've attached a sample of what I'm trying to accomplish which should help get a better understanding.

If you go to the paste sheet and have two agents in consecutive rows there's no problem, but as soon as there's a blank it's not continuing the sequence

Many thanks in advance