Formula to show results of evaluation tie match

Hi Glenn,

I have uploaded a new sample workbook with comments for results of "O".

If I was to calculate manually, it would be the general agreement of the assessment of "Exceptional/ Satisfactory/ Unsatisfactory".e.g. if 2 of the 3 have assessed as Satisfactory and 1 has
assessed unsatisfactory then the general agreement would be Satisfactory. If 2 have assessed as Satisfactory and 2 have assessed as Unsatisfactory then the general agreement will be a tie result.

Thanks