Comparing 2 columns

  • Thread starter Thread starter lynn
  • Start date Start date
L

lynn

I have 2 columns containing names (Last Name, First Name
in each). Column B is my primary data. I need to see if
any names in column B also appear in column A. Can
someone give me some suggestions on how to accomplish
this ?
 
I have 2 columns containing names (Last Name, First Name
in each). Column B is my primary data. I need to see if
any names in column B also appear in column A. Can
someone give me some suggestions on how to accomplish
this ?
Click to expand...

assume data starts in row 1
in C1 put
=COUNTIF($A$1:$A$100,B1)>0

it will return "TRUE" if the item in B1 is anywhere in column A and
"FALSE" if not.
 
Back
Top