Hi all, Hoping someone can help. I have 2 worksheets 'Sheet1' & 'Sheet2' in the same workbook. In both sheets in column A I have rows of numbers, eg; ' 233572-1'. What I want to know is if there are any identical values in column A from both sheets and highlight them, or return a value so I know the identical values. I did initially use the following code: Code: =COUNTIF(Sheet2!$A:$A, A1) In Sheet1 which returned a value which worked when I tested it by adding the same random numbers to both sheets but don't seem to be working on any of the real values I have? I am using Excel 2010. Thanks in advance.