True false function for alpha data

  • Thread starter Thread starter R Y
  • Start date Start date
R

R Y

Row # Column1 Column2 Outcome
1 80E 80E TRUE
2 999 80E FLASE
3 80E 80E TRUE
4 CB1 80E FALSE
5 80E 80E TRUE
6 999 80E FALSE
7 999 C76 FALSE

I'm trying to write a formula that gives me a true/false outcome for the
above data and the results would be where the outcome is located (completed
manualy)
 
I'm trying to write a formula that gives me a true/false outcome...

One additional idea might be:

=EXACT(A1,B1)

One difference is that if the strings are
80E & 80e, then Exact() would return False.
= = = =
Dana DeLouis
 
When I tried this I received all false outcomes.

Column1 Column2 =(A1=B1) Should Be
80E 80E FALSE TRUE
999 80E FALSE FALSE
80E 80E FALSE TRUE
999 80E FALSE FALSE
80E 80E FALSE TRUE
999 80E FALSE FALSE
999 C76 FALSE FALSE
C76 C76 FALSE TRUE
999 A09 FALSE FALSE
71O 52 FALSE FALSE
71O 52 FALSE FALSE
 
Have you checked for spare spaces or other non-printing characters?
What do you get for =LEN(A1) and =LEN(B1), copied down as appropriate?
 
Back
Top