| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data displayed that is not equal to FALSE in a row
=SUBSTITUTE(A1&B1&C1&D1,FALSE,"")
-- Gary''s Student - gsnu201001 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data displayed that is not equal to FALSE in a row
Thanks Gary. That works great!
"Gary''s Student" wrote: =SUBSTITUTE(A1&B1&C1&D1,FALSE,"") -- Gary''s Student - gsnu201001 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data displayed that is not equal to FALSE in a row
You are very welcome!
-- Gary''s Student - gsnu201001 "Mally" wrote: Thanks Gary. That works great! "Gary''s Student" wrote: =SUBSTITUTE(A1&B1&C1&D1,FALSE,"") -- Gary''s Student - gsnu201001 |
| Reply |
| 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 | |||
Linear Mode
