Yes,

I realise what your saying but like I said. I'm having problems with my internet and laptop. I will try to upload the workbook tomorrow. I'd like to get all the duplicate serials highlighted. So They are clearly visible and I can then move them on the system. I have used countif. But seem to have a lot of errors. I'm using 2003