Prevent duplicates from a range of cells

[MadBern]

Hi,
This probably has a really simple solution, but I can't seem to figure it out...
I'm trying to use Data Validation to prevent duplicates in some cells. It's easy enough to do this when it only has to look for the value in one spesific cell, but I need it to look in several.
I've tried many variations of AND, OR and COUNTIF.

Example:
I need it to return an error if someone tries to type in the same value in A3 as is found in the range A1:C2.


Any one got any clues?


- Mads

 

[tyija1995]

Hey, try use a custom data validation rule with COUNTIF.

In your example given, select cell A3 then make the rule as follows:
=COUNTIF(A1:C2,A3)=0

 

[MadBern]

Hey, try use a custom data validation rule with COUNTIF.

In your example given, select cell A3 then make the rule as follows:
=COUNTIF(A1:C2,A3)=0

Hi, thanks a bunch!
I knew it was gonna be that easy