Novice123456
01-23-2021, 08:09 PM
Hi Guys,
Can someone help make a UDF code that will do the following:
Note: Only VBA code to be used and no reference to any Excel functions required such as Application.Worksheet Functions. Any built-in VBA functions can be used such as sqr.
1. Base Data: Have 3 columns of indefinite length. Column1: Company Name, Column2: Rating, Column3: Coupon
2. Input will be two ranges of data i.e. Rating and Coupon.
3. It should be callable from within Excel (i.e. from a cell of worksheet).
4. Output requirements:
i) Code should identify all unique Credit Ratings and display them.
ii) The count of each Credit Rating should be displayed in the cell to the right of it the rating.
iii) The average value of the coupons against each credit rating should be displayed in the cell to the right.
iv) The population standard deviation of the coupons of that credit rating should be displayed in the cell to the right.
I am attaching the sample data file for reference as well.
Can someone help make a UDF code that will do the following:
Note: Only VBA code to be used and no reference to any Excel functions required such as Application.Worksheet Functions. Any built-in VBA functions can be used such as sqr.
1. Base Data: Have 3 columns of indefinite length. Column1: Company Name, Column2: Rating, Column3: Coupon
2. Input will be two ranges of data i.e. Rating and Coupon.
3. It should be callable from within Excel (i.e. from a cell of worksheet).
4. Output requirements:
i) Code should identify all unique Credit Ratings and display them.
ii) The count of each Credit Rating should be displayed in the cell to the right of it the rating.
iii) The average value of the coupons against each credit rating should be displayed in the cell to the right.
iv) The population standard deviation of the coupons of that credit rating should be displayed in the cell to the right.
I am attaching the sample data file for reference as well.