Loss1003
08-26-2016, 11:43 AM
Please see the below and help me figure out a formula to achieve the desired outcome in the result column.
So, if a value appears other than the word FALSE in the row, I’d also like that value to show up in column G
Column A
B
C
D
E
F
G
Ven A
Ven B
Ven C
Ven D
Ven E
Count of False in Row
Desired Result
FALSE
FALSE
FALSE
FALSE
FALSE
5
False
FALSE
FALSE
FALSE
FALSE
FALSE
5
False
FALSE
FALSE
FALSE
FALSE
FALSE
5
False
FALSE
FALSE
FALSE
FALSE
FALSE
5
False
AA
FALSE
FALSE
FALSE
FALSE
4
AA
FALSE
FALSE
FALSE
FALSE
FALSE
5
False
FALSE
FALSE
FALSE
FALSE
FALSE
5
False
FALSE
FALSE
FALSE
FALSE
FALSE
5
False
FALSE
FALSE
AZ
FALSE
FALSE
4
AZ
AC
FALSE
FALSE
FALSE
FALSE
4
AC
FALSE
FALSE
FALSE
FALSE
FALSE
5
False
FALSE
FALSE
FALSE
FALSE
FALSE
5
False
FALSE
FALSE
FALSE
FALSE
EE
4
EE
So, if a value appears other than the word FALSE in the row, I’d also like that value to show up in column G
Column A
B
C
D
E
F
G
Ven A
Ven B
Ven C
Ven D
Ven E
Count of False in Row
Desired Result
FALSE
FALSE
FALSE
FALSE
FALSE
5
False
FALSE
FALSE
FALSE
FALSE
FALSE
5
False
FALSE
FALSE
FALSE
FALSE
FALSE
5
False
FALSE
FALSE
FALSE
FALSE
FALSE
5
False
AA
FALSE
FALSE
FALSE
FALSE
4
AA
FALSE
FALSE
FALSE
FALSE
FALSE
5
False
FALSE
FALSE
FALSE
FALSE
FALSE
5
False
FALSE
FALSE
FALSE
FALSE
FALSE
5
False
FALSE
FALSE
AZ
FALSE
FALSE
4
AZ
AC
FALSE
FALSE
FALSE
FALSE
4
AC
FALSE
FALSE
FALSE
FALSE
FALSE
5
False
FALSE
FALSE
FALSE
FALSE
FALSE
5
False
FALSE
FALSE
FALSE
FALSE
EE
4
EE