data validation
 

Hi,
I like to know how i can limit cell to whole numbers only, but also avoid
duplication of the same number in different cells.

Tnx. in advance.

data validation
 

Assume the range of cells in question is A1:A10

Select the range A1:A10
Goto the menu DataValidation
Allow: Custom
Formula:

=AND(INT(A1)=A1,COUNTIF(A$1:A$10,A1)<2)

OK out

--
Biff
Microsoft Excel MVP


"jiji" wrote in message
...
Hi,
I like to know how i can limit cell to whole numbers only, but also avoid
duplication of the same number in different cells.

Tnx. in advance.

data validation
 

TNX.

"T. Valko" wrote:

Assume the range of cells in question is A1:A10

Select the range A1:A10
Goto the menu DataValidation
Allow: Custom
Formula:

=AND(INT(A1)=A1,COUNTIF(A$1:A$10,A1)<2)

OK out

--
Biff
Microsoft Excel MVP


"jiji" wrote in message
...
Hi,
I like to know how i can limit cell to whole numbers only, but also avoid
duplication of the same number in different cells.

Tnx. in advance.

data validation
 

You're welcome!

--
Biff
Microsoft Excel MVP


"jiji" wrote in message
...
TNX.

"T. Valko" wrote:

Assume the range of cells in question is A1:A10

Select the range A1:A10
Goto the menu DataValidation
Allow: Custom
Formula:

=AND(INT(A1)=A1,COUNTIF(A$1:A$10,A1)<2)

OK out

--
Biff
Microsoft Excel MVP


"jiji" wrote in message
...
Hi,
I like to know how i can limit cell to whole numbers only, but also
avoid
duplication of the same number in different cells.

Tnx. in advance.