Unique data in column

N

News

Hi,

I'd like to add a "validation" on a column : the written data must be single
(reference).
Is it possible and how ?

Thanks,
Laurent.
 
D

Domenic

If by single reference you mean that the data can only be entered once in
your column, then yes it's possible.

Assuming your data is to be entered in Column A, try,

Select range of cells
Data > Validation > Settings > Allow > Custom > Formula

=COUNTIF($A$1:$A$100,A1)=1
 
Top