Excel 2002: How to identify error in a column ?

  • Thread starter Thread starter Mr. Low
  • Start date Start date
M

Mr. Low

Hi,

Lets consider the table below:

A B
8 <---- Test Result
11 OK OK
12 OK OK
13 OK ERROR
14 OK OK


Column A and B are the result of analysing the data. All the rows need to
have OK to pass the test. If any row has an "ERROR", it failed the test.

May I know what formula at Cell A8 and B8 to pick up "OK" and "ERROR" in
column A and B respectively ?

Thanks

Low
 
In cell A8 try =IF(COUNTIF(A11:A14,"ERROR")>=1,"ERROR","OK")
and in B8 =IF(COUNTIF(B11:B14,"ERROR")>=1,"ERROR","OK")

This just prints error if at least 1 error is detected otherwise prints OK.

This is fine unless EORROR is mistyped.
 
Hi,

The following formula works for both columns:

=IF(COUNTIF(A11:A14,"ERROR"),"Error","OK")

You can simplify this down to

=IF(COUNTIF(A11:A14,"E*"),"Error","OK")

If this helps, please click the Yes button.

cheers,
Shane Devenshire
 
Back
Top