can i stop repeating values?
 

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.

can i stop repeating values?
 

Hi

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


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Haitham" wrote in message
...
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.

can i stop repeating values?
 

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" wrote in message
...
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.