I need to create a simple spreadsheet to forecast when an employee is forced
to have a rostered day off (RDO). Employees can only work a maximum of 13
consecutive days and are then forced to have an RDO.

To do this, I have an array (A1:A14). Cell A1 has the text "RDO" in it.
Cells A2:A14 have a value of "10" in each cell. I would like to insert a
formula into cells A15:A28. The formula needs to look back 14 cells and
return "RDO" in the respective cell within the array A15:A28 that is 14
columns from the last occurence of "RDO".

Hope this makes sense. Thanks in advance.
--
Regards
Matt