Error msg for Repated value in array

[Dackson]

Dear Friend,

I have one array B3:E6, I want to enter in this array only numeric value. I entered one value in the array (ex 32) again I enter repeated the same value in the array anywhere, then I want to show error massage like “Check again” otherwise OK. How I can solve this problem through data validation or other method?

Thanks for your patient.
Dackson Jose

 

[srinidhi]

Data>Validation and choose "Custom" , insert this formula

=COUNTIF($b$3:$e$6,b3)=1. This will pop up a message if a duplicate value is entered

 

[NARAYANK991]

Hi Jose ,

Try this :

=AND(FREQUENCY($B$3:$E$6,$B$3:$E$6)<=1)

Narayan

 

[Dackson]

Data>Validation and choose "Custom" , insert this formula

=COUNTIF($b$3:$e$6,b3)=1. This will pop up a message if a duplicate value is entered

Yes its working thanks to you,,,,,,,,,,

 

[Dackson]

Hi Jose ,

Try this :

=AND(FREQUENCY($B$3:$E$6,$B$3:$E$6)<=1)

Narayan

Thanks its working thanks to you.