Unique data in column or row in Excel

A

Ali

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?
 
S

Stefi

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:
 
R

Roger Govier

Hi Ali

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

Change references to suit column required.
 
Top