I am trying to automate the prodution of my schools exam timetable. The problem i have at the moment is that the exams are either a or p for am or pm. If someone is sitting more than one exam in the same a or p plot i have to assign them an order eg p1 p2 p3 and is determined by the number of people taking the exam. I therefore have columns with the candidate number, name, date. exam, a or p, number doing exam. Does anyone have a way of putting the a1 a2 p1 s2 etc into the next column so it is specific to the candidate and date and in order of number doing exam? Many thanks jack