Posted by Andy on October 23, 2001 12:15 AM
can any one tell me how to find if a value has been entered in a sheet already?
I need to have non adjacent columns compared - I have found the =IF(SUMPRODUCT((COUNTIF(A1:D12,A1:D12)>1)+0)>1,"Duplicates exist","") function but I can't make it work on non adjacent columns.
Sorry I'm not explaining this very well.basically I have some columns that can have duplicates in and some columns that every cell must be unique not just to that column but on the whole sheet.
Any help appreciated