Equal values in different fields in Excel
Posted on 2011-03-11
I have two different Excel sheets. I have copied all the columns of one into another and now I want to run a formula to check if the values of one column equal the other. No matter what formula I use, Excel is not recognizing the values of one of the columns as equal to the other.
For example, is not recognizing that ICF13X13P= ICF13X13P. I have formatted both columns as text and it still doesn't recognize them.
Any ideas? Thank you in advance.