Check contents of range...

neilmonk

New Member
Joined
Jun 21, 2004
Messages
22
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?
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

neilmonk

New Member
Joined
Jun 21, 2004
Messages
22
sneel3 said:
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

Active Member
Joined
Oct 9, 2002
Messages
331
IF(OR(MIN(A1:T1)<0,MAX(A1:T1)>20),"NOT OK",IF(SUM(A1:T1)=210,"OK","NOT OK")
 

Watch MrExcel Video

Forum statistics

Threads
1,118,380
Messages
5,571,796
Members
412,419
Latest member
acemali
Top