two identical values aren't equal according to xl 2000

  • Thread starter Thread starter matt
  • Start date Start date
M

matt

I am using an if statement to look for identical data in
two seperate worksheets. I know that there is identical
data, but the if statement does not think there are any.
After I retype the data, it works. Why must I retype the
data? Is there some sort of formatting that the if
statement doens't like?
 
Yep - They are not equal. One is likely to be numeric and one is likley to be text. You cannot
just change the format using the 'format as' option, it doesn't do that. Copy an empty cell,
select all your data and do Edit / Paste Special / Add and it will coerce all your data back to
numeric.
 
Back
Top