| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: Need to know the meaning of error meesage | Excel Discussion (Misc queries) | |||
| Excel 2002 produces error in calculation. | Excel Discussion (Misc queries) | |||
| Excel 2003 Identify a single character in column | Excel Worksheet Functions | |||
| Excel 2002 error in conversion | Excel Discussion (Misc queries) | |||
| Excel 2002 error | Excel Discussion (Misc queries) | |||
Threaded Mode
