Warn for duplicate numbers

English
#1

Hello.

I want to warn if I enter duplicate numbers in cells A1 to A100.
I used the following formula, but it gives warning only for cell A1!

COUNTIF(A1:A100,A1)=1

AFSHIN-08-34
AFSHIN-08-34497×571 17.9 KB

AFSHIN-08-39
AFSHIN-08-39920×503 36.2 KB

#2

Hint: check validity formula in A4.

#3

COUNTIF(A$1:A$100;A1)<=1 :heavy_check_mark:

3 Likes

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.