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:
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.
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.