set up a column in excel with unique entries

R

Richard

How does one create a column to accept only unique serial numbers. The
serial number will contain text if that matters.

Thanks in advance,
 
B

Biff

Hi!

Use Data Validation.

Select the range in question. Assume that range is A1:A10.

Goto Data>Validation
From the Allow list select Custom
In the Formula box enter:

=COUNTIF(A$1:A$10,A1)=1

OK out.

Biff
 
Top