How can I setup in Excel Worksheet Column a number is not repeat?

[Shahzad Zameer]

Dear All,

I want that in a Column a number should not repeat again. Suppose if I write
in Column A a number 7 then it can't be write again in same Column A. Please
help how to do this?

 

[RichardM]

Hi Shahzad

Select column A and go to Validation (on the Data menu)
select "Custom" in the "Allow" box and enter the formula:

=MATCH(A1,$A:$A,0)=ROW(A1)

then click OK

Any unique number is now allowed in column A but a duplicate will give
an error

 

[Shahzad Zameer]

Thanks a lot Mr. RichardM, it solved my problem.

Hi Shahzad

Select column A and go to Validation (on the Data menu)
select "Custom" in the "Allow" box and enter the formula:

=MATCH(A1,$A:$A,0)=ROW(A1)

then click OK

Any unique number is now allowed in column A but a duplicate will give
an error