Exact Function

K

Kim

I have to columns of numbers


Column A Column B Column C

I4C I4C =EXACT(A1,B1) ANSWER False


The above answer is True why am I receiving a
False answer in Column C? Both fields are the same????
 
D

Dave R.

You can check that there are no extra spaces in either one of them, and that
they both actually *contain* the same values (i.e., are not only formatted
to appear as ##c).
 
K

Kim

I've checked all the fields look like this

Column A Column B ColumnC (using exact function

M48 X79 TRUE
A26B M46B TRUE

Above are other examples with the wrong answer from
Microsoft. I'm not sure about your message below????
Both columns were downloaded from other databases should
I know something else??? Why did the EXACT function
provide the wrong information?????
 
D

Dave R.

I don't quite see what's going on with what you pasted in, but I'll say
again, and as Frank repeats, check for spaces and such.

Guessing that you want to go through a list and find nonmatches, you can try
something like this:

=TRIM(A1)=TRIM(B1)

or if for some reason you need to use exact,

=EXACT(TRIM(A1),TRIM(B1))

TRIM will remove nonprinting characters, like stray spaces after the text.
 
M

Mark Graesser

Hi Kim
As Jim and Frank point out, you might have some characters that you can't see, like spaces. Check the length of each value with

=LEN(A1) and =LEN(B1

You could try and clear these out by using the TRIM function

=EXACT(TRIM(A1),TRIM(B1)

As far as your second post goes, are you really getting TRUE values when the inputs are different

Good Luck
Mark Graesse
[email protected]
Boston M

----- Kim wrote: ----

I've checked all the fields look like thi

Column A Column B ColumnC (using exact functio

M48 X79 TRU
A26B M46B TRU

Above are other examples with the wrong answer fro
Microsoft. I'm not sure about your message below???
Both columns were downloaded from other databases shoul
I know something else??? Why did the EXACT function
provide the wrong information????

-----Original Message----
You can check that there are no extra spaces in either one of them, and tha
they both actually *contain* the same values (i.e., are not only formatte
to appear as ##c)
Click to expand...
 
M

Mark Graesser

Hi Dave
Don't know why I called you Jim in my post yesterday. I guess too many meetings and not enough coffee. Sorry about that

Regards
Mark Graesse
[email protected]

----- Mark Graesser wrote: ----

Hi Kim
As Jim and Frank point out, you might have some characters that you can't see, like spaces. Check the length of each value with

=LEN(A1) and =LEN(B1

You could try and clear these out by using the TRIM function

=EXACT(TRIM(A1),TRIM(B1)

As far as your second post goes, are you really getting TRUE values when the inputs are different

Good Luck
Mark Graesse
[email protected]
Boston M

----- Kim wrote: ----

I've checked all the fields look like thi

Column A Column B ColumnC (using exact functio

M48 X79 TRU
A26B M46B TRU

Above are other examples with the wrong answer fro
Microsoft. I'm not sure about your message below???
Both columns were downloaded from other databases shoul
I know something else??? Why did the EXACT function
provide the wrong information????

-----Original Message----
You can check that there are no extra spaces in either one of them, and tha
they both actually *contain* the same values (i.e., are not only formatte
to appear as ##c)
Click to expand...
 
D

Dave R.

Thanks Mark, no problem at all!



Mark Graesser said:
Hi Dave,
Don't know why I called you Jim in my post yesterday. I guess too many
Click to expand...
meetings and not enough coffee. Sorry about that.
Regards,
Mark Graesser
[email protected]

----- Mark Graesser wrote: -----

Hi Kim,
As Jim and Frank point out, you might have some characters that you
Click to expand...
can't see, like spaces. Check the length of each value with:
=LEN(A1) and =LEN(B1)

You could try and clear these out by using the TRIM function:

=EXACT(TRIM(A1),TRIM(B1))

As far as your second post goes, are you really getting TRUE values when the inputs are different?

Good Luck,
Mark Graesser
[email protected]
Boston MA

----- Kim wrote: -----

I've checked all the fields look like this

Column A Column B ColumnC (using exact function

M48 X79 TRUE
A26B M46B TRUE

Above are other examples with the wrong answer from
Microsoft. I'm not sure about your message below????
Both columns were downloaded from other databases should
I know something else??? Why did the EXACT function
provide the wrong information?????
Click to expand...
 
Top