Hi,
I am creating a spreadsheet for work in which the start and finish times for
employees are recorded. I am using the following formula:
=IF(E4=$C5,"Start",(IF(E4=$D5,"Finish","-")))

This formula works for all of the values, EXCEPT when It reaches column x,
this is the only column that won't display ""Finish" in it. is there some
reason it won't recognise x as being the column name? how can I get around
this. At the moment it won't register anything in column x, except "-".
Very Frustrating.

Thanks in advance for your help