Search results

You've done it again Sajan. Can't thank you enough. Best regards.

Hello again everyone. I hate to reopen an old thread like this, but I need your guidance here yet again. I had my original question answered by Sajan's great formula: =SUMPRODUCT(SIGN(ISNUMBER(MATCH(B2:B12, Moody_LowRating,0)) + ISNUMBER(MATCH(C2:C12, SP_LowRating,0)))) I have a slight...

This appears to be working perfectly. Thank you very much Sajan! Best regards.

Faseeh, that is great, thank you. It is unfortunately still just a small step away from what I need though. The problem is that one rating agency may rate it investment grade, while the other may rate it below investment grade. On the otherhand, BOTH agencies may rate it below investment...

Thank you Hui and Narayank991. I attempted a Pivot Table as well Hui, but I'm not sure how to identify duplicates when doing so. I want to count all bonds that are below investment grade, but if the same row of data contains a below investment grade rating for column 1 and column 2, I don't...

Hi everyone. I'm having trouble filtering some data that I believe requires the use of the COUNTIF or SUMPRODUCT formulas. I've gotten close using variations of the two, but need the help of this great community! I have a large spreadsheet of bond data that contains two columns displaying...