software

I have the following monitoring tool:

EngineTrading
1TRUE
1TRUE
1TRUE
2TRUE
2FALSE
2TRUE

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 quot;truequot;,
return the value that is in ColB. I've filled in the table below with the
result I am trying to achieve.

EngineStringStatus
1ABCABC
2EFG

Thank you in advance.

I'll assume that the monitoring data is on Sheet1 and the table you're trying
to compile on Sheet2 with column headers in row 1. In cell C2 on Sheet2,
enter the formula
=if(sumproduct(--(Sheet1!A$1:A$10000=a2),--(Sheet1!B$1:B$10000=quot;FALSEquot;))=0,b2,quot;quot;)
This counts the number of times FALSE appears with the particular engine,
and sets copies the value from b2 to c2 if the count is 0.
HTH. --Brucequot;carlquot; wrote:

gt; I have the following monitoring tool:
gt;
gt; EngineTrading
gt; 1TRUE
gt; 1TRUE
gt; 1TRUE
gt; 2TRUE
gt; 2FALSE
gt; 2TRUE
gt;
gt; I am looking for a formula to place in ColC of this table that will look at
gt; the monitoring tool above and if all values for a given engine are quot;truequot;,
gt; return the value that is in ColB. I've filled in the table below with the
gt; result I am trying to achieve.
gt;
gt; EngineStringStatus
gt; 1ABCABC
gt; 2EFG
gt;
gt; Thank you in advance.
gt;
gt;
gt;

Thank you Brian. I tried this formula but it returns the value in b2 even if
some values in Sheet1!B$1:B$10000=quot;FALSEquot; are indeed false.

Am I doing something wrong ?

quot;bpeltzerquot; wrote:

gt; I'll assume that the monitoring data is on Sheet1 and the table you're trying
gt; to compile on Sheet2 with column headers in row 1. In cell C2 on Sheet2,
gt; enter the formula
gt; =if(sumproduct(--(Sheet1!A$1:A$10000=a2),--(Sheet1!B$1:B$10000=quot;FALSEquot;))=0,b2,quot;quot;)
gt; This counts the number of times FALSE appears with the particular engine,
gt; and sets copies the value from b2 to c2 if the count is 0.
gt; HTH. --Bruce
gt;
gt;
gt; quot;carlquot; wrote:
gt;
gt; gt; I have the following monitoring tool:
gt; gt;
gt; gt; EngineTrading
gt; gt; 1TRUE
gt; gt; 1TRUE
gt; gt; 1TRUE
gt; gt; 2TRUE
gt; gt; 2FALSE
gt; gt; 2TRUE
gt; gt;
gt; gt; I am looking for a formula to place in ColC of this table that will look at
gt; gt; the monitoring tool above and if all values for a given engine are quot;truequot;,
gt; gt; return the value that is in ColB. I've filled in the table below with the
gt; gt; result I am trying to achieve.
gt; gt;
gt; gt; EngineStringStatus
gt; gt; 1ABCABC
gt; gt; 2EFG
gt; gt;
gt; gt; Thank you in advance.
gt; gt;
gt; gt;
gt; gt;

Are the false values text or are they the results of logical comparisons? If
the latter, remove the quotes around the FALSE.
--Bruce

quot;carlquot; wrote:

gt; Thank you Brian. I tried this formula but it returns the value in b2 even if
gt; some values in Sheet1!B$1:B$10000=quot;FALSEquot; are indeed false.
gt;
gt; Am I doing something wrong ?
gt;
gt; quot;bpeltzerquot; wrote:
gt;
gt; gt; I'll assume that the monitoring data is on Sheet1 and the table you're trying
gt; gt; to compile on Sheet2 with column headers in row 1. In cell C2 on Sheet2,
gt; gt; enter the formula
gt; gt; =if(sumproduct(--(Sheet1!A$1:A$10000=a2),--(Sheet1!B$1:B$10000=quot;FALSEquot;))=0,b2,quot;quot;)
gt; gt; This counts the number of times FALSE appears with the particular engine,
gt; gt; and sets copies the value from b2 to c2 if the count is 0.
gt; gt; HTH. --Bruce
gt; gt;
gt; gt;
gt; gt; quot;carlquot; wrote:
gt; gt;
gt; gt; gt; I have the following monitoring tool:
gt; gt; gt;
gt; gt; gt; EngineTrading
gt; gt; gt; 1TRUE
gt; gt; gt; 1TRUE
gt; gt; gt; 1TRUE
gt; gt; gt; 2TRUE
gt; gt; gt; 2FALSE
gt; gt; gt; 2TRUE
gt; gt; gt;
gt; gt; gt; I am looking for a formula to place in ColC of this table that will look at
gt; gt; gt; the monitoring tool above and if all values for a given engine are quot;truequot;,
gt; gt; gt; return the value that is in ColB. I've filled in the table below with the
gt; gt; gt; result I am trying to achieve.
gt; gt; gt;
gt; gt; gt; EngineStringStatus
gt; gt; gt; 1ABCABC
gt; gt; gt; 2EFG
gt; gt; gt;
gt; gt; gt; Thank you in advance.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;