Solved

# VBA EXCEL assign and categorize data

Posted on 2009-05-14
Medium Priority
441 Views
Hi, another question: I have a sheet (is attached) where I need to categorize data according to the Rating. On sheet "Info" we can find the rating (column B) for the particular bond - on sheet "Risk Criteria" we can find the the Riskrating (column E) which indicates that A+ to A- will get the rating 3 (this inculdes also A as it is in between A+ and A-). Everything BB+ and below will get a 5 - if there is no rating it should also get a 5. (AAA = 1; AA+, AA, AA- = 2; A+, A, A- = 3; BBB+, BBB, BBB- = 4, the rest =5). The result should be displayed in sheet "Calculation". The CUSIP/ISIN is the ID. If you have any help how to solve this I would be very grateful.
Moreover, I would like to classify the country by assinig them another rating. This rating still has to be calculated according to the data i am downloading on sheet "Country". Here we can see that there are many bonds with a number (yield) - this data actually has to be sorted by the numer (yield) so that we can perform the assignment of the Risk Criteria. On sheet "Risk Criteria" we can the 20% having the highest number (yield) should get the number 5 (80.01% - 100%) this should include all the countries on the bottim of the table on sheet "Country". If there is not country found the Bond should get a 5 (as with the Rating). The result should be displayed on sheet "Calculation". Again, I am grateful for any help.
RatingCountry.xls
0
Question by:kbrasco
• 2

LVL 7

Accepted Solution

Eoin Ryan earned 2000 total points
ID: 24386369
Hello,

Have a look and let me know, it was a bit confusing from your description but I think I got most of your requirements.
RatingCountry-1-.xls
0

Author Comment

ID: 24386608
Yes that works for me. Thanks
0

LVL 7

Expert Comment

ID: 24386968
Just to note you had "Germany" in your country list twice, this will skew your results by a very small percent.
0

## Featured Post

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.