comparing columns to find dup's
 

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 !

comparing columns to find dup's
 

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.
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"stacey" wrote:

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 !

comparing columns to find dup's
 

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 !



"PJFry" wrote:

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.
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"stacey" wrote:

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 !