using exact formula to compare cells
 

I'm trying to compare the values in two columns by using this formula
{=OR(EXACT(B3, $A$2:$A$394))} however, it does not seem to be picking up when
the cells contain the same information. It just returns a FALSE answer.
--
Garry

using exact formula to compare cells
 

Garry,
My limited testing worked i.e. if returned TRUE if column A
range matched B3.

Extraneous blanks (or "hidden" characters) on either set of data will cause
a mismatch.

Look at TRIM/CLEAN functions to remove this type of problem.



"Garry" wrote:

I'm trying to compare the values in two columns by using this formula
{=OR(EXACT(B3, $A$2:$A$394))} however, it does not seem to be picking up when
the cells contain the same information. It just returns a FALSE answer.
--
Garry

using exact formula to compare cells
 

Thanks, Unfortunately that didn't work,

This functin works when i try it on a small data range (as it did for you i
imagine) But when i try it on my series, which is about 600 rows, it just
returns false.

If i copy the cell from one field to the next it picks it up. It seems as
though something is stopping the calculation
--
Garry


"Toppers" wrote:

Garry,
My limited testing worked i.e. if returned TRUE if column A
range matched B3.

Extraneous blanks (or "hidden" characters) on either set of data will cause
a mismatch.

Look at TRIM/CLEAN functions to remove this type of problem.



"Garry" wrote:

I'm trying to compare the values in two columns by using this formula
{=OR(EXACT(B3, $A$2:$A$394))} however, it does not seem to be picking up when
the cells contain the same information. It just returns a FALSE answer.
--
Garry

using exact formula to compare cells
 

Garry,
I tried a simple test with data range A2:A1000 and value in
A700: worked OK.

Do you want to send me the w/book? (toppers at
REMOVETHISjohntopley.fsnet.co.uk)

"Garry" wrote:

Thanks, Unfortunately that didn't work,

This functin works when i try it on a small data range (as it did for you i
imagine) But when i try it on my series, which is about 600 rows, it just
returns false.

If i copy the cell from one field to the next it picks it up. It seems as
though something is stopping the calculation
--
Garry


"Toppers" wrote:

Garry,
My limited testing worked i.e. if returned TRUE if column A
range matched B3.

Extraneous blanks (or "hidden" characters) on either set of data will cause
a mismatch.

Look at TRIM/CLEAN functions to remove this type of problem.



"Garry" wrote:

I'm trying to compare the values in two columns by using this formula
{=OR(EXACT(B3, $A$2:$A$394))} however, it does not seem to be picking up when
the cells contain the same information. It just returns a FALSE answer.
--
Garry

using exact formula to compare cells
 

Morning,

have tried to email you the w/book but it wont recognise your email address!
seems i'm beset by technical problems at the moment!

--
Garry


"Toppers" wrote:

Garry,
I tried a simple test with data range A2:A1000 and value in
A700: worked OK.

Do you want to send me the w/book? (toppers at
REMOVETHISjohntopley.fsnet.co.uk)

"Garry" wrote:

Thanks, Unfortunately that didn't work,

This functin works when i try it on a small data range (as it did for you i
imagine) But when i try it on my series, which is about 600 rows, it just
returns false.

If i copy the cell from one field to the next it picks it up. It seems as
though something is stopping the calculation
--
Garry


"Toppers" wrote:

Garry,
My limited testing worked i.e. if returned TRUE if column A
range matched B3.

Extraneous blanks (or "hidden" characters) on either set of data will cause
a mismatch.

Look at TRIM/CLEAN functions to remove this type of problem.



"Garry" wrote:

I'm trying to compare the values in two columns by using this formula
{=OR(EXACT(B3, $A$2:$A$394))} however, it does not seem to be picking up when
the cells contain the same information. It just returns a FALSE answer.
--
Garry