To see how many people are on holiday during the summer I made a name list with a startdate and enddate
If someone is on holiday excel puts a "1" in the correct date in the columns E to DY.
But if one person is going on holiday for more than 1 time there will be two rows of that person.
What I want that for a person who is going on more than 1 holiday all the absent days will be filled with "1" after his name
In the example Person 3 is going on 2 holidays, as you can see, the name is copied twice in the monthnames and 2 rows with "1"s.
Also, is there any way I can write this more efficient?
If someone is on holiday excel puts a "1" in the correct date in the columns E to DY.
But if one person is going on holiday for more than 1 time there will be two rows of that person.
What I want that for a person who is going on more than 1 holiday all the absent days will be filled with "1" after his name
In the example Person 3 is going on 2 holidays, as you can see, the name is copied twice in the monthnames and 2 rows with "1"s.
Also, is there any way I can write this more efficient?
