comparing columns to find dup's

[stacey]

i have 1 worksheet with 2 columns....i need to know the names that show in
both columns.

i know there is a =countif formula but i cant find it anywhere.

thx !

 

[PJFry]

You have two options:

You can use a countif in C2. That would be =COUNTIF(A:A,B2)
THis assumes your first column in A, the second is B and you would countif
in C.

The other option is a VLOOKUP. Either way, you will be able to flag the
duplicates.

 

[stacey]

this is what i am using:

=COUNTIF(B:E,G2)

but column B & E have some repeating last names. how do i incorporate the
formula to go off of ab / de. this would catch the full name & be able to
find all the dup's. column a & d being the first name & b & e being the last
name.

thx !