What is wrong with this Countif formula?

[tigerzen]

Clearly Joe is on both lists but the formula ignores it. Both Joe entries have 3 characters in them, it doesn't matter where Joe sits on the second column he is ignored.

Book12
	A	B	C
1	Original	New	Outcome
2	Joe	Joe
3	Poor	Harry	This is on both lists
4	Fred	Sam
5	Harry	Pete
6	Tom	Fred	This is on both lists
7	Joe
Sheet1

Cell Formulas
Range	Formula
C2:C7	C2	=IF(COUNTIF($A$2:$A$7,B2)=1,"This is on both lists","")

 

[AhoyNC]

It's because count of Joe in column A equals 2 so COUNTIF($A$2:$A$7,B2)=1 is FALSE.
Maybe try:

Book1
	A	B	C
1	Original	New	Outcome
2	Joe	Joe	This is on both lists
3	Poor	Harry	This is on both lists
4	Fred	Sam
5	Harry	Pete
6	Tom	Fred	This is on both lists
7	Joe
Sheet1

Cell Formulas
Range	Formula
C2:C7	C2	=IF(COUNTIF($A$2:$A$7,B2)>=1,"This is on both lists","")

 

[rlv01]

The formula should use greater than or equal to 1

IF(COUNTIF($A$2:$A$7,B2)>=1,"This is on both lists","")

Update: I see @AhoyNC beat me to it

 

[tigerzen]

Thank you both, I should have picked that up. Been staring at a computer screen too long! Appreciate the quick turnaround.

 

[AhoyNC]

Happens to all of us. Thanks for the feedback.