+ Reply to Thread
Results 1 to 5 of 5

Custom average function

  1. #1
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    Custom average function

    can this be done with Worksheet functions:
    Please Login or Register  to view this content.
    It works like a normal AVERAGE only the 1,2,3,4,5 are now replaced by O,M,V,RV,G
    Last edited by rwgrietveld; 12-11-2009 at 09:08 AM.
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016
    Posts
    3,390

    Re: Custom average function

    Didn't work when tested - sorry
    Last edited by sweep; 12-11-2009 at 09:10 AM. Reason: Didn't work when tested

  3. #3
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    Re: Custom average function

    Spot on Sweep. Thx

  4. #4
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016
    Posts
    3,390

    Re: Custom average function

    Did that work for you? I just tried it out and I'm not getting what I expected.

  5. #5
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Custom average function

    Though I suspect you need to add a ROUND to the Average output if you wish to replicate your UDF Ricardo ?
    that being said your Select Case arguments overlap so it's not quite clear if your boundaries are round related or not

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1