Calculate highest occurence of 2 pairs between a range

[sans]

Hello,

I have been trying to find a way to do a certain calculation in excel but with no luck so far. I just simply can't figure it out.

The names in the table are irrelevant. Please have a look at the results column in the attached workbook as it is clear what I'd like to do.

If there is an easy way to get the highest percentage, it would be simply amazing.

Thank you

Sans

[NBVC]

I am not sure what you mean by which two pairs give highest percentage?

What are the expected results and based on what?

[sans]

Hi NBVC,
thank you for your reply.

Basically, if I was going to do this manually I would need to do all possible combinations of two pairs, to see which two pairs give the highest percentage. For example, I would need to start with


=IF(OR(AND(O7=CHAR(252),P7=CHAR(252)),AND(Q7=CHAR(252),R7=CHAR(252))),CHAR(252),CHAR(251))

then

=IF(OR(AND(O7=CHAR(252),P7=CHAR(252)),AND(Q7=CHAR(252),S7=CHAR(252))),CHAR(252),CHAR(251))

then

=IF(OR(AND(O7=CHAR(252),P7=CHAR(252)),AND(Q7=CHAR(252),T7=CHAR(252))),CHAR(252),CHAR(251))

then

=IF(OR(AND(O7=CHAR(252),P7=CHAR(252)),AND(Q7=CHAR(252),U7=CHAR(252))),CHAR(252),CHAR(251))


then

=IF(OR(AND(O7=CHAR(252),P7=CHAR(252)),AND(Q7=CHAR(252),V7=CHAR(252))),CHAR(252),CHAR(251))

until I reach

=IF(OR(AND(W7=CHAR(252),X7=CHAR(252)),AND(Y7=CHAR(252),Z7=CHAR(252))),CHAR(252),CHAR(251))

Is it possible to skip the above and use one formula that can show which two pairs would give the highest percentage as in the workbook?

Thank you for your help,
Sans

[NBVC]

If I understand correctly, I think you will need to use either some massive formulas or it will more likely need VBA....

[sans]

Yes, I'll probably need to do it manually. I was just wondering if there was a simpler method.

Thank you for replying
Sans