Consulting

Results 1 to 5 of 5

Thread: VBA UDF required

  1. #1

    VBA UDF required

    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.
    Attached Files Attached Files

  2. #2
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,234
    What is your budget ?

  3. #3
    How are IT services priced? I'm not familiar with those calculations. If you can share any contact details then I can share my exact requirements (which are a little more detailed than I've mentioned above).

  4. #4
    Cross posted without links https://www.mrexcel.com/board/thread...uired.1159405/

    Also sounds like homework.

  5. #5
    Knowledge Base Approver VBAX Wizard
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,375
    …and
    Seeking Tutor for Replicating Unique Value, COUNTIF, AVERAGEIF and STDEVIF in VBA
    https://www.excelforum.com/excel-pro...if-in-vba.html
    VBA UDF required - Excel VBA / Macros - OzGrid Free Excel/VBA Help Forum
    https://www.ozgrid.com/forum/index.p...-udf-required/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •