Excel formating into groups

Blakespops

I have a worksheet in excel that each column a-h has 3 values 1.0,2.0,2.1 shared equally over 36 rows but I have been asked to work out the best way to divide the 12 of each value in each column to make it so out of every row I can link a minimum of three results no matter what the value is however no more than three of any value are repeated in the final result so it is an instant fail if out of the 36 rows any one value is repeated more than 3 times in any given row. example below although not fully sorted as doing manually as can not do formulas in excel so please help

1.0 1.0 2.1 2.0 2.0 2.1 2.1 2.0
1.0 1.0 2.0 2.1 2.0 2.0 2.1 2.0
1.0 2.0 1.0 2.0 2.0 2.1 2.1 2.1
1.0 2.0 2.0 2.0 2.1 2.0 2.0 2.1
2.0 2.0 2.1 2.1 2.1 2.0 2.1 2.0
2.0 2.0 2.0 2.1 2.1 2.1 2.0 2.0
2.0 2.1 2.0 1.0 2.0 2.0 2.1 2.1
2.0 2.1 2.1 1.0 2.0 2.1 2.0 2.1
2.1 1.0 2.0 1.0 2.1 2.0 2.1 2.1
2.1 1.0 2.0 1.0 2.1 2.1 2.0 2.0
2.1 2.0 2.0 1.0 2.1 2.1 2.0 2.1
2.1 2.0 2.0 1.0 2.1 2.1 2.1 2.0

EchoLocation

If I've understood you correctly, try this in Cell I1...

=IF( OR( COUNTIF(A1:H1,1.0)>3, COUNTIF(A1:H1,2.0)>3, COUNTIF(A1:H1,2.1)>3), "FAIL", "PASS")

...then drag it down against all rows.