One way, though not scaleable:

=IF(COUNTIF(A2:F2,1)0,1,0)+IF(COUNTIF(A2:F2,2)0, 1,0)+IF(COUNTIF(A2:F2,3)0,1,0)+IF(COUNTIF(A2:F2,4 )0,1,0)+IF(COUNTIF(A2:F2,5)0,1,0)+IF(COUNTIF(A2: F2,6)0,1,0)

Regards

Trevor


"nospaminlich" wrote in message
...
I'm trying to create a formula which checks that a range of cells e.g.
A2:F2
contain all the values 1,2,3,4,5,6 irrespective of which cell each number
is
in.

Unfortunately, everything I've tried has failed so any help would be
appreciated.

Thanks