PDA

View Full Version : Formula for value in Row



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