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

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?

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

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 wrote:
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?

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

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

"RichardM" wrote:

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 wrote:
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?