On Wed, 7 Apr 2010 05:42:01 -0700, Shazza
wrote:

This is some sample data of what informaion i am using
A1 A2 A3 A4
A5
Hunter's, Charles, Smith, Abrasive Wheels Regs 1/2-day course, 26-May-09
Hunter's, David Jones, Abrasive Wheels Regs 1/2-day course, 26-May-09
Leslie Ltd, Nigel Will Abrasive Wheels Regs 1/2-day course,
10-Nov-09
Johnston Ltd, James, Smith, Asbestos Awareness 1/2-day course 05-Nov-09
Johnston Ltd, Ivor, Smith Asbestos Awareness 1/2-day course 05-Nov-09
Amenity, Ross Jones Asbestos Awareness 1/2-day course 17-Dec-09
Garriock, Bruce, Willia Basic First Aid (1 day course)
30-Jan-09
Garriock, Debbie Smith Basic First Aid (1 day course)
30-Jan-09

I need a formula that will count all the courses that have run and as you
can see from the dates there can be several names set to one particular date.
I do not want it to pick up on the same date. ie Asbestos Awareness was run
twice so i need it to count it as 2. Basically i do not want to count how
many people attended the course i want to know how many courses run.

--
Thank you for reading my post. Hopefully you can answer my querie

Is it the case that only one course will taught on any given date? Or might
you have two different courses on the same date?
--ron