Problem finding duplicate values
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 |
Problem finding duplicate values
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 |
All times are GMT +1. The time now is 03:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com