Hi shg,

Thanks for the reply.

I tried to be as concise as possible if that is the problem. I mentioned the function consolidate that is in excel. But consolidate apart from other mathematical functions makes the arithmetic average. I need a similar function or method the way consolidate works but to find the geometric mean instead of the arithmetic mean. Hope this helps. If no please I appreciate if you specify where is the problem in my message.