sample3.xlsxHello,

I have been stuck on a formula for a while and would be very appreciateive for any help that you may be able to provide.

I have a spreadsheet that is attached... Which is used to allocate leave to employees.

The way that it works is that each employee places a bid consisting of 4 preferences. The calculation column is used to calculate whether the employee is entitled to leave based on the number of slots that is available. If the employee's number 1 bid is successful (represented by a 1) the rest of the bids for preferences (2,3,4( fail (represented by a 0). However if bid 1 fails due to not having enough slots available, bid 2 then has the opportunity to be changed to 1.

Any help that could be preovide would be very much apreciated, and i hope that my explanation makes sense!


Kind regards,


Andrew