using exact formula to compare cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
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.
 
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,
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)
 
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!
 
Back
Top