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
Reply With Quote