ExcelBanter - Data displayed that is not equal to FALSE in a row

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data displayed that is not equal to FALSE in a row (https://www.excelbanter.com/excel-discussion-misc-queries/256016-data-displayed-not-equal-false-row.html)

Mally

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.

Gary''s Student

Data displayed that is not equal to FALSE in a row

=SUBSTITUTE(A1&B1&C1&D1,FALSE,"")
--
Gary''s Student - gsnu201001

Mally

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

Gary''s Student

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

All times are GMT +1. The time now is 04:20 PM.