Exact match with value

[jiteshrohira]

Check	Value 1	Value 2	Value 3	Value 4	Value 5	Value 6	Value 7	Value 8	Value 9	Value 10
2	2	3	2	2	2	2	2	2	2	2
2	2	2	2	2	2	2	2	2	2	2

<colgroup><col><col span="10"></colgroup><tbody>
</tbody>

i have the information

Basically the check column should match all the values. So if Check is 2 and the corresponding values are as above it should give me exact match

so the in the first instance value 2 =3 does not match the check column which is 2 so the first line is a fail

 

[Puertorekinsam]

What is it you want it to do when it fails? Are we changing the color? are we putting a 'fail' in the third row?

 

[jiteshrohira]

i will add a row after the last check ie after value 10 and populate Fails if the value attribues are not matching

 

[Weazel]

maybe something like...

=COUNTIF(B2:K2,A2)=10

which would return TRUE or FALSE.

Assuming that your data starts in A1

 

[Puertorekinsam]

... Row or Column? Row's a horizontal. Columns are vertical....

So if I understand what you are saying, the entire first row will fail because there is a 3 in the row. But the entire second row will pass since there are only 2s?

So assuming your table is in Cells A1 through K3
Put this formula in L2:

=IF(COUNTIF(B2:K2,A2)/COUNT(B2:K2)<>1,"Fail","Pass")