Help With If Formula
I have the following monitoring tool:
Engine Trading
1 TRUE
1 TRUE
1 TRUE
2 TRUE
2 FALSE
2 TRUE
I am looking for a formula to place in ColC of this table that will look at
the monitoring tool above and if all values for a given engine are "true",
return the value that is in ColB. I've filled in the table below with the
result I am trying to achieve.
Engine String Status
1 ABC ABC
2 EFG
Thank you in advance.
|