|
|
And lo on Wed, 12 Mar 2008 10:47:34 -0000, scott <sco### [at] laptopcom> did
spake, saying:
>>>> 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 o
ne.
=geomean(range) which does exactly the same as your function.
--
Phil Cook
--
I once tried to be apathetic, but I just couldn't be bothered
http://flipc.blogspot.com
Post a reply to this message
|
|