View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carl
 
Posts: n/a
Default 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.