can i stop repeating values?

[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.

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.

"Haitham" <[email protected]> wrote in message
news:[email protected]...
> 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.

[Arvi Laanemets]

Hi

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


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )


"Haitham" <[email protected]> wrote in message
news:[email protected]...
> 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.