Hi! I have three columns: A, B and C. They all contain credit rating information in the form of a grade (eg. AAA or AA-). I want to check the ratings in column A, B and C and then get a final score in column D. The rating in one or more columns can be empty. If there is only one rating in the columns A, B and C then that rating is the final score. If there are two different ratings, the lowest one shall be the final score. If there are more than two ratings then the two ones that gives the highest final score is chosen. If they are different the lowest of those two shall be chosen. If the two best ratings are the same then they shall be used as a final score.

The ratings scale works like this (from best to worst): AAA, AA+, AA, AA-, A+, A, A-, BBB+, BBB, BBB-.

So there are two problems: comparing the ratings since they are not numerical, and then writing a worksheet function that gives the right final score rating.

If anyone please can help me with this I would be most grateful! Thanks a lot!