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

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Watch MrExcel Video

Forum statistics

Threads
1,118,169
Messages
5,570,656
Members
412,335
Latest member
cinciri99
Top