| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data displayed that is not equal to FALSE in a row
In row 1 cells A1-D1 contain formulas (IF/AND statements). In cell E1 I want
whatever word that is not equal to FALSE to be displayed. A B C D E 1 FALSE FALSE Under FALSE Under The words can appear in any of cells A-D in each row as below. A B C D E 1 FALSE FALSE Under FALSE Under 2 FALSE On FALSE FALSE On 3 Over FALSE FALSE FALSE Over 4 FALSE FALSE FALSE On On Thank you in advance for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I Change Displayed Data Through Data Validation? | Excel Discussion (Misc queries) | |||
| how to update data displayed from a UDF when the source data chang | New Users to Excel | |||
| Why isn't all the data in the cell displayed? | Excel Discussion (Misc queries) | |||
| Cell Displayed Does Not Equal Cell Copied | Excel Worksheet Functions | |||
| format data displayed on Excel data entry form | Setting up and Configuration of Excel | |||
Threaded Mode
