validation problem

[dam0cles]

I am currently using this :

=COUNTIF($A$2:$A$20,A2)=1

as the data validation for a row of I.D. numbers, I would also like to limit the entries to numerics only. (I haven't got a clue how the validation I am using works, google works amazing miracles for the ignorant.)

Any help would be greatly appreciated, thanks in advance...

[oldchippy]

Here's a link on Data Validation, this should help

http://www.contextures.com/xlDataVal01.html

http://www.contextures.com/xlDataVal08.html

[dam0cles]

Thanks for the links oldchippy, though I am sure they will be very useful for other things I may need. I cannot see anything on there that will help with my specific problem, nor can i find anything that will help me figure it out myself.

[Carim]

Hi,

Use Data Validation
Custom
in the Formula area
=Isnumber(a1)

[dam0cles]

I am already using this in the custom :

=COUNTIF($A$2:$A$20,A2)=1

do i just add it too the end like so:

=COUNTIF($A$2:$A$20,A2)=1=Isnumber(a1)

I have absolutley no understanding of what the code means, please forgive my ignorance, this is the 1st time I have ever tried to do anything like this.

P.S. Thanks again for the replies, really quick :>

[Carim]

Hi,

I do not know your spreadsheet, but my guess is

=And(COUNTIF($A$2:$A$20,A2)=1,Isnumber(A2))