can i stop repeating values?

H

Haitham

if I want to make each cell with unique value in specific Coolum in the
meaning that if I tray to write the same value again would not be accepted.
 
A

Arvi Laanemets

Hi

Use data validation
For column A:
Data>Validation...>Custom with Formula = (COUNTIF(A:A,A1)<2)
 
G

Guest

Hi

Select your column (D, for example), go to Data/Validation and select
Custom. In the Formula box type:
=COUNTIF(D:D,D1)<2

Hope this helps.
Andy.
 
Top