Search results

Narayan, that works perfectly! Many thanks.

Hi, yes. that's correct, its alway a combination of company and month. I don't need a list of names, its just the total number of people (attendees) in a given month that have received training by a particular trainig company. :)

Hi Kevin, thanks for the formula. That will give me a count of how many people attended over the given period, but if one person attended 2 courses it counts them twice,and what I need is a formula that recognises a duplicate and does not double count them. So if john attendes 2 courses in...

Thanks Kevin, I'll give it a try.

I’ve been viewing the forum for some time and I can see that there are lots of questions around similar issues but I am struggling to find a solution that matches what I need. I analyse attendees on courses for a client. I need to provide them monthly on the number of individuals that...