Check contents of range...

[neilmonk]

Hi,

I want to be able to do the following, I'm sure it's possible, but I don't know how to go about it...

Cells A1 to T1 (inclusive) contain the numbers 1 to 20 inclusive, in any order.

I want a formula so that U1 to check that each preceding column has the numbers 1-20 inclusive in any order and to place some sort of confirmation in column "U".

Any ideas?

 

[sneel3]

IF(OR(MIN(A1:T1)<0,MAX(A1:T1)>20),"NOT OK","OK")

 

[neilmonk]

IF(OR(MIN(A1:T1)<0,MAX(A1:T1)>20),"NOT OK","OK")

Thats fantastic, just the job, BUT,

each number can only appear once.

Is there a way to build this in to your forumla?

 

[sneel3]

IF(OR(MIN(A1:T1)<0,MAX(A1:T1)>20),"NOT OK",IF(SUM(A1:T1)=210,"OK","NOT OK")