Hi,

Thanks for responding so quickly! And sorry for not being clear - 'Fully Compliant' just means that they have completed all of the required courses between B:N that have a 'yes' in the column. Any of the blank cells in columns B:N just mean that they do not need to complete the courses in the particular column heading to be compliant.

There isn't anything to link each employee to each location I'm afraid. They kind of link to every single location in a way. I need to find out exactly how many employees are at the least compliant with that location, depending on whether they have completed all of the courses with a 'yes' on that particular row. So each employee may potentially be counted more than once in the figures, but that's ok, as they can be compliant to work at more than one location.

Hope that makes sense?

Many thanks

Harry