Hi
I am trying to compare numbers in column 2 againt column 1 and return yes or no if they exist in column 3.
Hovever these numbers are 8digit and begin with zero.
I am using the countif function.
But when i compare in col2 '01111111' with '1111111' in col1 I am getting a 'yes' in col3 where as I should be getting a 'no'.
Any ideas anyone??
cheers
Bookmarks