Hi - I have a sheet with two columns of student results. Some columns contain empty cells (where the pupil was not present in school) and some contain values (where the pupil was present. Is there a way excel can copy the value in the first column, but if that cell is empty, copy the value in the second cell?
Solved by T. E. in 25 mins