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?
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?