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


"Ron Rosenfeld" wrote:

On Wed, 7 Apr 2010 03:27:02 -0700, Shazza
wrote:

I have a spradsheet in Excel 2007 that contains a list of company names,
course names, delegate names and dates that they attended courses.

I need to do a count of the courses but can not figure out how to do it.
there are lots of dates that are the same and lots of names that are the same
so i want it to count them only if they are different which is why i though
the date would be better to work on

Not sure if this makes any sense. Let me know if you need more info

Post some sample data and desired results.
--ron
.