Hey Team,
I have a worksheet with different classifications on performance. For instance, one area may be "Fail", "Needs Improvement", Achieves", or "Excels".
I want a cell to show the lowest classification. Its too easy to show if there is a failure, I can use an OR function to show if there is a failure. IF there is only Excels, then I can use the AND function.
But suppose there are Two Excels, an Achieves, and one Needs Improvement, how can I get Excel to show the Needs Improvement?
Thanks Team
Respectfully
-Phil
Bookmarks