So I am trying to create a Vacancy calendar that i can use to compile automatically and distribute the available vacancy week (max 3 employee in vacancy during the same week)
Here my idea:
B5,H5,O5 etc ... are the Week # the employee must choose.
for B6,H6,O6 etc... i used =COUNTIF and take the data from a table where each employee made their choice
On the table, the choice 1 is the one that shall be used if there are 3 or less employee that chose it,
If there is more than 3 people who chose it, the second choice will instead be used and the 1 choice should be eliminated.
I am struggling to find a solution on how the code can determine the priority of employee, cause the older employee will alway have priority over the newer employee.
Solved by E. J. in 30 mins