I'll re-post this in the programming section

"Pete_UK" wrote:

Okay, well thanks for feeding back.

Pete

On Jan 15, 10:27 am, nmpb wrote:
Thank you for that, it does work. The issue is that I have a sheet of over
40,000 rows, also I have noticed that I have duplicates in the column B,
which will have to be excluded. I think I am going to need a program to do
it.