I have a problem with posibility of repeating data in column. Of course this
is normal behaviour of Excel, but I need to assure unique data in column. Is
there a way to do this without an extra effort?

Hi Ali,

Try to use this formula in Data/Validation/Custom:

=ISERROR(MATCH(A1,INDIRECT("A1:A"&CELL("row",A1)-1),0))

Regards,
Stefi

€žAli€� ezt Ã*rta:

I have a problem with posibility of repeating data in column. Of course this
is normal behaviour of Excel, but I need to assure unique data in column. Is
there a way to do this without an extra effort?

Hi Ali

Assuming your column of data entry is A, mark the range of cells you want to
validate
DataValidationCustom in white pane type =COUNTIF(A:A,A1)<2

Change references to suit column required.

--
Regards

Roger Govier


"Ali" wrote in message
...
I have a problem with posibility of repeating data in column. Of course
this
is normal behaviour of Excel, but I need to assure unique data in column.
Is
there a way to do this without an extra effort?