HI there,
I am creating a calendar whereby the rule is the lead name cannot be on holiday at the same time as the subordinate names (see Rules tab)
In tab '01.04' I have a formula that is working for everyone except the last one highlighted in yellow. In addition considering I only use 2 rows in my formula, how is the pink highlighted cell giving 3 answers?
Please try: tick the box for Column J Row 2 = should put a H in his cell and a R in column E & I - but doesn't.
tick the box for Column I Row 2 = should put a H in his cell and a R in column J, F & E - which it does BUT I'm only referring to 'Rules' rows 2 and 3? So how is it picking up the 3 names correctly?
I'm very puzzled!
As a side note: it also won't clear the cells if you tick and untick unless you 'save' the file :S
Anybody that can help is a legend! :D
Bookmarks