Identify Duplicate Items Based On Multiple Criteria

Hi,

I have a rather large list (approx 20,000 rows) of suppliers of
training. I have their name in column 1, type of training they provide
in column 2 (e.g. health and safety, first aid, generic stuff) and the
name of the course in column 3.

e.g.
Col 1
Provider 1
Provider 1
Provider 1
Provider 2
Provider 3

Col 2
H&S
H&S
First Aid
H&S
Other

Col 3
5 Day Course
5 Day Course
3 Day Course
Chainsaw Training
Something else

The problem is many of the courses are duplicated so one supplier of
one type of course with a given name might have fifty entries that are
identical. What I would like to do is to have one entry for each
variation but can't think how. I did consider an array but only end up
counting the number of duplicates :(

Any ideas would be most appreicated!

Best Regards,


CalumMurdo Kennedy

.