The file named Nancybonds.xlsx gives the bond rating for several bonds in a previous and future month. You want to efficiently count how many bonds were downgraded. Unfortunately, each company is listed in more than one row. Assuming you have sorted the data on the company name, how would you determine the number of downgraded bonds?

Transcribed Image Text:

F22 Clipboard A 1. 2 Bond ID 3 111013ADO 4 111013AB4 5 111013AA6 313917AF3 7 46062RAG3 6 8 46062RAH1 9 681936AK6 10 681936AJ9 11 81234PAF9 12 817565AJ3 13 723686AA9 Paintin F 32 33 ISSUER ID BSY BSY BSY FCH IPX IPX OHI OHI S SRV PHB fr B AAB AAB Font C company BRITISH SKY BROADCAST BRITISH SKY BROADCAST BRITISH SKY BROADCAST FELCOR SUITES INTERPOOL INC INTERPOOL INC OMEGA HEALTHCARE OMEGA HEALTHCARE SPRINT NEXTEL CORP SERVICE CORP INTL 20 among 8 issuers, there are 6 issuer who get downgrade 21 there are 1 issuer who get upgrade Alignment PIONEER HY-BRED INTL IN ABN-AMRO BANK ABN-AMRO BANK 14 00077QAA8 15 00077DAF6 16 17 18 Try to determine how many company whose rating was changed by "Standard and Poor" 19 In this case, there are 8 issuers 26 I use contif and put a if function in it but it does not work out 27 28 29 30 31 D 24 I have thousands thousands of this kind of bond id in the database by month 25 Last month Score Score now 22 Goal 23 How do I write a formula to see how many issuers are upgrade or downgrade (by month)? 10 10 10 12 12 12HH72444 54 E Number 9 9 11 11 11 13 13 G Score change downgrade 6 10 5 F 44 19 OO Styles H