Looking to Eliminate Duplicates between 2 columns.

I hope you can see the image ok.

No, I can't.

But since we are on an excelforum it is more usefull to add a small exelfile, without confidential information.

Also add manualy the expected result in your file.

Most forummembers don't want to reproduce your image, just to help you.

is the exact phrase identical in column A

"buy houses fast"

is that exactly the same in column A
or are you trying to get an approximate match
like
"but some houses as fast as you can"

will not match

you can use conditional formatting

or out a formula in column C and then sort to get all duplicates together

in c2 put
=countif( A:A, B2 ) >0
yow will get a true or false

as requested an excel example would be much better

Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.