Re: Finding duplicate names

From: Max (demechanik_at_yahoo.com)
Date: 06/09/04 

Date: Wed, 9 Jun 2004 10:05:12 +0800

Try this ..

Assuming the data in cols A and B are in row1 down

Put in C1: =TRIM(A1&" "&B1)

Put in D1:

=IF(COUNTIF($C$1:C1,C1)>1,"Duplicate","Not a Duplicate")

Select C1:D1 and copy down

For the sample data in your post
C1:D4 will now contain:

Jen Black....Not a Duplicate
Jack Black..Not a Duplicate
Jen white.....Not a Duplicate
Jen white.....Duplicate

Think the first occurence of "Jen white" should rightly tag as
"Not a Duplicate" instead of "Duplicate"
(as indicated in your post) 

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----
"Matt in AZ" <anonymous@discussions.microsoft.com> wrote in message
news:85A1AC52-21E3-4AB8-8F19-F8E9845528F6@microsoft.com...
> Okay, I got a list of people's names.  Column A are first names.  Column B
is last names.  In colum C I need a formula that will put the word duplicate
if the last names and first names are the same.  This is the formual that I
think can be modified, but I'm not sure how to modify it:
>
> =IF(COUNTIF(Range1,???)>1,"Duplicate","Not a Duplicate")
>
> This is kind of what I want:
> Column A    Column B     Column C
> Jen              Black           Not a duplicate
> Jack             Black           Not a duplicate
> Jen             white           Duplicate
> Jen             white           Duplicate
>

Relevant Pages

  • Re: Violation of Primary Key
    ... Maybe you could post your DML and sample data to reproduce the problem? ... You're trying to insert a duplicate ... making changes and I receive an error that says the following: ... > Violation of PRIMARY KEY constraint 'PK_CUSTOMERS'. ...
    (microsoft.public.sqlserver.server)
  • Re: How to: Remove duplicate TITLES but keep a COUNTRY code
    ... Please provide the table schema and sample data. ... > This works perfectly and removes any duplicate entries with the same TITLE ... country of ORIGIN codes such EEC - USA - CAN - DOM ...
    (microsoft.public.sqlserver.programming)
  • Re: Finding duplicate names
    ... > Assuming the data in cols A and B are in row1 down ... > Jack Black..Not a Duplicate ... > "Matt in AZ" wrote in message ...
    (microsoft.public.excel.misc)
  • Re: Deleting duplicate records based on lowest number
    ... > Can some one assist with deleting duplicate records based on lowest ... all occurences of a duplicate F1 value. ... Sample Data ... FROM tblDUP AS D0 ...
    (microsoft.public.access.gettingstarted)
  • Re: Nested Sets and custom sorting
    ... Would it be possible for you to post some sample data (in the ... form of INSERT statements - just enough to duplicate the problem) and the ... complete code you're currently using to populate the tree? ...
    (microsoft.public.sqlserver.programming)