Help ! formula showing blank cells, missing something

[AbuFragile]

Hello,

I previously posted a problem about workers, and the formula seems to leave blanks cells and I would like to get some help if there's something missing in the formula.

The idea is filling 6 workers each day knwing that the worker is already admissed and not yet resigned.

Thank you

[Bo_Ry]

I'm not get this. Your Tabelle2 Employee ID is only run from E1-E199 and the rest are just duplicate.

Could you help to mock up manual result that you expect?

[AbuFragile]

I want to assign 6 workers in each day without repeating the same worker in that day, knowing that workers works in that day so the Admission < Date < Demission

[GeoffW283]

Bo's formula in your previous thread gave you precisely what you asked for. Unfortunately I don't think what you asked for matches your real need.

You're now saying that we can't repeat the same worker in that day. So can we use them the following day?? So that:
1-Jan-2016: E01 E02 E03 E04 E05 E06
2-Jan-2016: E01 E02 E03 E04 E05 E06
Regardless of the answer it's still not clear what meaningful information you are trying to extract.

What do you ultimately want to use this spreadsheet for? For example are you trying to find how many employees you had on any given date? If so the answer is straightforward. If it's something else then can you explain? - not the details but the general concept.

Thanks for your patience

[GeoffW283]

Oh. I just notice that this thread has been marked as solved despite no solution!