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

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)

"nicoll" wrote in message
...

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