G
Guest
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!
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!