Check Duplicate Cells

[Bharatdubole]

Hi All

Please help me,

I have A & B column A column has names & B column has Addressess. In some cells of B column name has been copied.

My problem is that, i have to check cells that in which names are copied.


Thanks in advance

[:) Sixthsense :)]

Assuming that the data start from 2nd Row since 1st row will have column headers.

In C2
=IF(A2=B2,"This Cell","")

Or

=IF(ISNUMBER(FIND(B2,A2)),"This Cell","")

Apply filter in Column-C and select "This Cell")

[Bharatdubole]

Thanks Sixthsense

I am not geting right answer. here I want to say another way. see A cell has one text & B cell has more than one text. Text of A cell is found in to the some B cell &

I have to check that B cells only.

Thanks

Assuming that the data start from 2nd Row since 1st row will have column headers.

In C2
=IF(A2=B2,"This Cell","")

Or

=IF(ISNUMBER(FIND(B2,A2)),"This Cell","")

Apply filter in Column-C and select "This Cell")

[[email protected]]

If you need to find A in B then put below formula in column C; drag to the end

=IF(ISNUMBER(FIND(A2,B2)),"This Cell","")

Apply filter in Column-C and select "This Cell")

[:) Sixthsense :)]

Thanks Sixthsense

Have you tried the second formula suggested in my previous post?

[Bharatdubole]

Thanks dear friend

please see my attachment

Picture1.jpg



Thanks.

If you need to find A in B then put below formula in column C; drag to the end

=IF(ISNUMBER(FIND(A2,B2)),"This Cell","")

Apply filter in Column-C and select "This Cell")

[Bharatdubole]

Yes i have used that formula but it gives answer, if A & B cell is exactly same. But B cell has not only text as A. B has other text also.

[:) Sixthsense :)]

In I2 cell

Please Login or Register  to view this content.

Or

=IF(AND(G2="",H2=""),"",IF(ISERR(SEARCH(G2&",",H2)),FALSE,TRUE))
Drag it down.