K
kray
I'm having problem trying to make value A1 = B1 when
values are copy and pasted.
A1=c106 and B1=c106 both are identically the same but
would get a "False" answer
c106 c106 False (formula =a1=b1 )
I tried pasting special with value and even saved the
file as text only and imported back to excel but still
get "False" answer. The Only way I would get a True is
when I type over A1 with the same value (c106). I have
about 20 values that should give me a "True" answer but
it doesn't.
Any help are apprecaited.
values are copy and pasted.
A1=c106 and B1=c106 both are identically the same but
would get a "False" answer
c106 c106 False (formula =a1=b1 )
I tried pasting special with value and even saved the
file as text only and imported back to excel but still
get "False" answer. The Only way I would get a True is
when I type over A1 with the same value (c106). I have
about 20 values that should give me a "True" answer but
it doesn't.
Any help are apprecaited.