Unique data in column or row in Excel
 

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?

Unique data in column or row in Excel
 

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?

Unique data in column or row in Excel
 

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?