Cross referencing outcomes are genuine

ExcelAmateur2014

New Member
Joined
Dec 17, 2014
Messages
32
Hi

I am looking to find some sort of formula which will check the answers to 10 questions before it an ascertain whether the Overall Outcome is consistent with the answers to the previous questions and if the overall outcome is inconsistent then it would flag the result in Red so that I can easily identify the potential error.

I have uploaded the data to drop box via the below link


https://app.box.com/s/tcvbkidj578zpart4awemlm1f0eecevu


To summarise, SUITABLE outcome can be contradicted by a single NO or UNCLEAR Question before it. UNSUITABLE outcome can only be affected by an UNCLEAR question before it, Unclear question would override everything.

With SUITABLE overall outcome this would be OK as long as there are not any NO or UNCLEAR outcomes in the previous Questions. Or even better would be that it only consists of YES and N/A outcomes and MUST have at least 1 YES in the Question sections
With UNSUITABLE overall outcome this would be OK as long as there are not any UNCLEAR outcomes in the previous Questions. Or even better would be that it only consists of YES, NO and N/A outcomes and MUST have at least 1 NO in the Question sections
With UNCLEAR overall outcome this would only be OK if at least 1 UNCLEAR in the Question sections

Thanks in advance
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Watch MrExcel Video

Forum statistics

Threads
1,123,400
Messages
5,601,462
Members
414,451
Latest member
jrose7

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top