If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
"Great minds ..." ;-)
Jerry Myrna Larson wrote: Yes. I thought of that this AM, but you beat me to it! On Fri, 10 Sep 2004 12:07:35 GMT, "Jerry W. Lewis" wrote: Or more generally =EXP(AVERAGE(IF(ISNUMBER(A1:J900),LN(A1:J900)))) which preserves the property of GEOMEAN that non-numeric data is ignored. Jerry |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
use of geomean in query | sotiris_s | Running & Setting Up Queries | 3 | November 13th, 2008 04:16 PM |
geomean | sotiris_s | Running & Setting Up Queries | 2 | July 16th, 2004 05:14 AM |
geomean | RK | Worksheet Functions | 5 | April 5th, 2004 02:56 AM |
Geomean in an Array Formula | forevergrateful | Worksheet Functions | 2 | March 2nd, 2004 10:11 AM |