Can I find duplicate phrases (not just occurrences of single words)?

Hi all,

I have two worksheets with journal article information from two different sources and I'd like to identify duplicates. The columns I'd like to compare contain several word titles like this (I don't know what these titles will be - there are hundreds of them).

Sheet 1 Column A
Hospital-based strategies contributing to percutaneous coronary intervention time reduction.
Out-of-Hospital Cardiac Arrest
Black widow spider bite.
Acute internal jugular venous thrombosis from dialysis catheter.
A Phased Approach to Cardiac Arrest Resuscitation Involving Ventricular Fibrillation and Pulse less Ventricular Tachycardia
Biochemical issues in emergency medicine: diagnostic and therapeutic considerations of selected toxic presentations.

Sheet 2 Column B
Electrocardiographic Patterns Mimicking ST Segment Elevation Myocardial Infarction
Pathophysiology and Definitions of Seizures and Status Epilepticus
The Diagnosis and Management of Seizures and Status Epilepticus in the Prehospital Setting
A Phased Approach to Cardiac Arrest Resuscitation Involving Ventricular Fibrillation and Pulse less Ventricular Tachycardia
Out-of-Hospital Cardiac Arrest

I'd like Sheet 2 Column C to say "duplicate" or "not duplicate" (or any similar wording! ) if duplicate titles are detected. Is this possible for cells with multiple words?

Thanks!!!

THANKS!!! I think it's almost working - one issue is my B sheet has a period after the titles and the other sheet doesn't. Could that make a difference? Because I notice the only two that are showing up as "duplicate" are one with a ? at the end, and one without a period at the end...

Hmm, that seems to give me No Duplicate for everything, rats! I'll keep trying and making sure I'm copying in the formula correctly. I can also Find and Replace the period in Column B and that seems to make the original formula work. Thanks!!

Attaching a file (it's just publication data from databases like PubMed) - you'll see the columns I'm referring to are Sheet 1 Column B and Sheet 2 Column D. Easiest route might be to remove the periods, but if there's a way around it, great! It's not just these 80 or so publications as you can imagine, or I wouldn't be looking for a way to streamline this!

Thanks - always grateful for help!!

judgeh59, I think that is working! Need to go teach a class (not on Excel, obviously) so I'm going to start with one of my clean sets (I've messed around with some of them too much) and I think this is a go. I'll wait to revisit to mark it SOLVED but I think we're there.

Thank You Thank You Thank You - this Forum is truly amazing!

It's working! Wish I could give reputation score - it would be a 10+. Thank you so much!