Extract only those lines which guarantee minimum 2 correct.

Using Excel 2010

Hello,

I have here 27 combinations within 3 columns created by 1X2, 3^3=9

Is there any excel VBA that can extract out of 27 only those rows that guarantee 2 match correct within any of 27 combinations.

Combinations sheet attached.

Regards,
Moti

Originally Posted by JohnTopley

.. not possible ...how can you guarantee any match result is correct?

Hello JohnTopley,

Searching some ware I find may this use Linear algebra maths or compares difference among 3 columns or 3 rows 1 sign difference I am not sure.

Here are the 6 row I have extract manually checking one by one in 4 month time where you will see In the each of 27 combinations there is 2 matches correct.

Not sure this could be done with VBA. Please see the attached worksheet with example.

Regards,
Moti

Hello Good morning, please any help thank you. Regards, Moti