Finding Duplicates

  • Thread starter Thread starter Connie
  • Start date Start date
C

Connie

Is it possible to put a formula in column D that would
look at the adjacent cell in column C and find the
duplicate in Col. A, and yield what cell the identical is
found in column A? And if there is no duplicate, it would
be blank.

An example is shown here. For example CP9300 in Col. C is
also in A40

COL.A COL.B COL.C COL. D
CF03003 A774 CP9300 A40
CF03005 A704 CP9300T A41
CF05001 A758 CP9425T
CP04070A A703 CP9250 A38
CP04080 A724 CP04100A A20
CP04080A A705 CP09165
CP04090A A707 CP04080 A16
 
Hi
try the following to indicate a duplicate in D1
=IF(COUNTIF($A$1:$A$100,C1)>=1,"Duplicate","")
copy down

To get the row number of the FIRST duplicate entry in column A enter
the following in E1:
=IF(D1="Duplicate",MATCH(C1,$A$1:$A$100),"")
copy down
 
Connie

one way:

=IF(ISNA(ADDRESS(MATCH(C2,A:A,0),1,4,1)),"",ADDRESS(MATCH(C2,A:A,0),1,4,1))

and drag down

Regards

Trevor
 
Back
Top