Excel 2002: How to identify error in a column ?
 

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

--
A36B58K641

Excel 2002: How to identify error in a column ?
 

How do you set up a Break Even Analysis Work sheet
"Mr. Low" wrote:

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

--
A36B58K641

Excel 2002: How to identify error in a column ?
 

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.

"Mr. Low" wrote:

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

--
A36B58K641

Excel 2002: How to identify error in a column ?
 

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

"phildy" wrote:

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.

"Mr. Low" wrote:

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

--
A36B58K641