Yes,

What I done was select my first cell, as the formula cell in my range. So basic, I just couldn't see it.

Can I ask if it's possible now that that's sorted. If you can get a written response. For example, cell B10 has been highlighted as a duplicate. Can I now get cell C10 to say 51 Para ?

Is this possible ?