Re: Identify Duplicate Items Based On Multiple Criteria

Hi,

What you need to do then, like removing the duplicate entries or just
you want to mark them.

That will be helpful to know to help you


Thanks,
Shail


calummurdo@xxxxxxxxx wrote:
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

.

Relevant Pages

  • Re: Identify Duplicate Items Based On Multiple Criteria
    ... What you need to do then, like removing the duplicate entries or just ... I have a rather large list of suppliers of ... in column 2 (e.g. health and safety, first aid, generic stuff) and the ... Provider 1 ...
    (microsoft.public.excel.worksheet.functions)
  • ADO connection and database password
    ... In a database I check for duplicate entries of ... Dim cnn As New ADODB.Connection ... to Cancel the Entry?", 20, "Duplicate Organisation Name") ... the database with either share-level or user-level ...
    (microsoft.public.access.security)
  • Re: Prevent Duplicate Records
    ... It's a known fact that copy-paste or dragging down will defeat data ... validation. ... If you're trying to prevent duplicate entries using DV, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Prevent Duplicate Records
    ... validation. ... If you're trying to prevent duplicate entries using DV, ... On Error GoTo ErrorHandler ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Deleting duplicate entries from MySQL database table
    ... No Primary Key, Unique Key, Validation process. ... Now it is desired that all the entries with duplicate entries gets ...
    (comp.lang.php)