Problem finding duplicate values

N

nicoll

I am using an if statement to find duplicate values in a column , now there
is a problem I can't work out.

A21 and A22 both contain the value 322 (copied from another sheet) and the
script doesn't pick them up them as identical values.

However if I do =A21-A22 the answer is zero, edit/find 322 picks up both
cells, the formats are identical as far as I can see.

If I type 322 in A21 and re run the script they are picked up as identical,
but if I type 322 in A22 and re run the script they are not picked up as
identical.

I'm baffled, I'd welcome any suggestions.

Thanks
 
B

Bob Phillips

Nicoll,

Sounds like one is text and one is numeric. Try using VALUE(A21)-VALUE(A22)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top