can this be done with Worksheet functions:It works like a normal AVERAGE only the 1,2,3,4,5 are now replaced by O,M,V,RV,GPlease Login or Register to view this content.
can this be done with Worksheet functions:It works like a normal AVERAGE only the 1,2,3,4,5 are now replaced by O,M,V,RV,GPlease Login or Register to view this content.
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
Didn't work when tested - sorry
Last edited by sweep; 12-11-2009 at 09:10 AM. Reason: Didn't work when tested
Spot on Sweep. Thx
Did that work for you? I just tried it out and I'm not getting what I expected.
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
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks