Comparing Data in Two columns

[mazher]

Hi,

I need forums help in this regard.

I have text entries in column A and Column B. starting from A2 and B2

I Column C , I need some formula that checks the values of Column B in Column A and writes "No Need" adjacent to values of column B in column C.

Regards

Mazher

 

[Akashwani]

Hi Mazher,

Does this help?....

Excel Workbook
	A	B	C
1	Data1	Data2	Result
2	Cat	Horse	No Need
3	Dog	Cow	No Need
4	Pig	Rat
5	Cow
6	Bull
7	Mouse
8	Horse
Sheet1

Ak

 

[mazher]

Hi Akashwani,

Thanks for the help

MaZhEr

 

[bosco_yip]

A bit shorter :

=IF(COUNTIF(A$2:A$8,B2),"No Need","")

Regards

 

[mazher]

Thanks Bosco