Formula to show results of evaluation tie match

Hi,

I am seeking help in a formula to show the results from evaluation that either shows if the consensus is either Exceptional, Satisfactory, Unsatisfactory base on the evaluation selection from other people.

Column "O" should show the consensus of "K-N" but I cant seem to figure it out.

I have attached a sample with drop list selection for "K-N"

This has also been posted in another thread/ forum that was for a pass/fail formula that was resolved.


https://www.excelforum.com/excel-for...-with-tie.html



Thanks in advance