Quote Originally Posted by newdoverman View Post
If where you show bold the whole row is bold, then you can use the Find and Select. In the Find, leave the Find What blank and click on Format (down diamond) and select BOLD from the font options. Click FIND ALL.

A small window will open with all the items that were found. Select all in that window using Ctrl + A all the bold font in the worksheet will be selected. Close the Find and Select dialogue and before doing anything else Ctrl + C to copy the selected areas.

Create a new worksheet within the same workbook and Paste. Only the Bold entries will be pasted. If you try to copy directly to another workbook, the whole range is copied and not just the selected area copied. Export the new worksheet to the new workbook by right clicking the tab of the new worksheet and click on Move or Copy....follow the prompts.
Actually, I'm sorry but my post was misleading I think. What I meant is that I needed the formula to make those entries bold or highlight them!
Anyway i think I found a solution, that I will merge those two columns and then highlight the duplicate ones and then clean them in a different sheet.

Thank you everyone for your help.