>>>> in VBA you'd have to write an explicit FOR loop 
>>>
>>> Not in Excel. What are you smoking? :-)
>>
>> Really? Care to explain that one?
> 
> Off the top of my head:
> 
> =product(range)^(1/count(range))
> 
> ...unless there is some geometric mean function, I didn't search for one.

Ah. In other words, "you don't need to code this because it's already 
pre-defined".

Or, to put it another way, I picked a bad example. ;-)

-- 
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*

Post a reply to this message