I'm doing a staff rota for a department with 5 sections. There are 32 individuals and each must not appear in more than one section at any one time (on one line). Can excel check and highlight any person appearing more than once, perhaps using an array formula?
No, I'm not much good at it either (so the wife says) but if we keep you up here at the top maybe someone will come up with a solution. If you see your post slipping down the list just add a 'bump' to move it back up top. TR
Thanks VoG and TommyRed. I've cracked it, after modifying VoG's formula. I set up the rota in rows, on a worksheet called 'rota' and I put the list of names on a worksheet called 'check'. I assigned a name (names) to the range containing the list of names. On the sheet called 'check', I entered the formula in the first cell corresponding to the first cell of the rota, then autofilled.
If a name occurs twice I get the answer 2, 1 for once and 0 if a name is missing altogether.
This thread is now locked and can not be replied to.