two identical values aren't equal according to xl 2000

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?
 
K

Ken Wright

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding multiple values from matched search results 3
V Lookup and Paste Special 6
retain value and delete format 7
how to compare formula's values? 4
Using validation to make data appear or not 2
How to sort data in Excel 2000 5
"IF" stmt says two cells are different but they are NOT 2
Need to count on two columns 1

Top